Looking for next number in sequence

A

Alex.W

I am looking for a cell formula that will look for the largest number in
column "A" in another sheet and return the next number in the sequence.
 
E

Ember

Any suggestions on how to make this work when your cells have text?

At the top of my spreadsheet I have a cell that indicates the next number to
be used. This is because the entries are sorted by a field other than this
identifier, and new entries are added after a row has been inserted in the
correct place. Therefore, the cell at the top is important to know what next
number can be used.

The format for the "number" is C00001, C00002, C00003, ect. the =MAX(A:A)+1
solution does not work for me because the prompt inidactes that it will
ignore text.

Thanks!
 
J

JBeaucaire

I would use similar but different approach. Remove the C and leadin
zeros from the existing ID numbers, leaving only the real numbers

Then highlight the entire range and apply a custom number format of

C0000

That will cause 35 to appear as C00035...but the raw number of 35 i
still visible

Then in the "next number" box at the top, just let is show the Ra
number to type next...36, not C00036. When they type in 36, it wil
appear as C00036

Now your MAX formula will work
 
Top