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
|