Looking for next number in sequence

  • Thread starter Thread starter Alex.W
  • Start date Start date
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.
 
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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find values across a row and return a text value from the same column 2
re-numbering or sequence priorities formula 2
select a range in a column 4
running number sequences 1
Formula for Numbers in Running Sequence 1
Continuous Invoice Nos. 3
Display Missing invoice numbers from a sequence. 2
Help needed 0

Back
Top