Empty rows count

[Paul]

Colum A contains the name of the product:

Apples

Oranges

Nuts

Blubbery



Column B contains the codes used incremented by 1, used today

7225

7226

7227

7228



Next day oranges are still in the table but not used, and I need "Nuts" to
show 7226:

Apples 7225

Oranges

Nuts 7226

Blubbery 7227



7225 is a reference number manually entered.



Thanks,

Paul

 

[Teethless mama]

Assume B1: = 7225

In B2: =MAX($B$1:B1)+1

Copy down

 

[T. Valko]

That won't exclude oranges.

Next day oranges are still in the table but not used

 

[Paul]

Thanks a lot!

Assume B1: = 7225

In B2: =MAX($B$1:B1)+1

Copy down

 

[Teethless mama]

You're Welcome!

Thanks a lot!