| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count filled data rows until empty | Excel Discussion (Misc queries) | |||
| Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
| How do I sort with empty rows between none empty rows? | Excel Worksheet Functions | |||
| Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
| Can Excel "slide up" rows with content thru empty rows to condense | Excel Worksheet Functions | |||
Hybrid Mode
