Number + 1 ???

Well-known Member
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

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

eggyjla

Active Member
Do you mean using the =RANK() function?

mosiki

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

Mosiki

Well-known Member
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

Board Regular
Try:

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

Relates to column A

Mosiki

Well-known Member
Try:

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

Relates to column A

Mosiki

Awesome, Thank you

=max(a:a)+1

Replies
4
Views
319
Replies
2
Views
890
Replies
3
Views
259
Replies
4
Views
336
Replies
4
Views
208

1,191,203
Messages
5,985,248
Members
439,953
Latest member
suchitha

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back