Check numbers in row and show next numer in a row

[perko121]

Hi,


I'm trying to get a formula that will recognize next ongoing number in a list from F1:F30 and show it in B2 cell

photos in attachment examples

Thank you

[Pete_UK]

Try this in B2:

=MAX(F1:F30)+1

Hope this helps.

Pete

[perko121]

it works

thank you

[Pete_UK]

That was a quick one!

Glad to help, and thanks for the rep.

Pete