Number + 1 ???

[Utradeshow]

Hi Guy's,

I have a workbook with numbers in a column. Is there a formula that could look at the column of numbers then determine the next highest number?

Thank you

 

[eggyjla]

Do you mean using the =RANK() function?

 

[mosiki]

=large(A:A,1) -highest
=large(A:A,2) -2nd highest......etc

Mosiki

 

[Utradeshow]

I'm not really sure. Here is what I'm looking for.

Say I have a column with various numbers

103658
103659
103662
103663

The formula would look at these numbes and determine the next available highest number is 103664

 

[mosiki]

Try:

=(large(A:A,1))+1

Relates to column A

Mosiki

 

[Utradeshow]

Try:

=(large(A:A,1))+1

Relates to column A

Mosiki

Awesome, Thank you

 

[Scott Huish]

=max(a:a)+1