| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatically numbering rows
I wish to have rows automatically numbered in column "A" according to the
content in column "B". If column "B" has text or numbers in a cell I do not want to number that row in column "A". If column "B" is blank in a cell I want to number that row in column "A". I found the following formula that works the opposite of what I want "=IF(B1<"",COUNTA($B$1:B1)&".","")" . What would the formula be if I wanted to numerically count the blank cells in "B" and skip the context cells in "B"? Thanks for you consideration. Regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use "find / replace" to automatically "Insert Rows" in a do. | Excel Discussion (Misc queries) | |||
| Automatically inserting rows | Excel Worksheet Functions | |||
| How to copy values in various rows automatically | Excel Discussion (Misc queries) | |||
| Numbering of Grouped Rows | Excel Discussion (Misc queries) | |||
| How do I make Excel automatically adjust a row's height once I in. | Excel Worksheet Functions | |||
Threaded Mode
