Empty rows count
 

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

Empty rows count
 

Assume B1: = 7225

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

Copy down


"Paul" wrote:

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

Empty rows count
 

That won't exclude oranges.

Next day oranges are still in the table but not used

--
Biff
Microsoft Excel MVP


"Teethless mama" wrote in message
...
Assume B1: = 7225

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

Copy down


"Paul" wrote:

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

Empty rows count
 

Thanks a lot!

"Teethless mama" wrote in message
...
Assume B1: = 7225

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

Copy down


"Paul" wrote:

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

Empty rows count
 

You're Welcome!

"Paul" wrote:

Thanks a lot!

"Teethless mama" wrote in message
...
Assume B1: = 7225

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

Copy down


"Paul" wrote:

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