Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to number only rows used --
I'm trying to automatically number rows that have been used, example if there
is a number in B17 then in A17 is one, if there isn't a number in B18, leave bank and is a number in B19 then in A19 it would enter 2 -- -- Thanks so much--Paula |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to number only rows used --
Try this formula entered in A17:
=IF(B17="","",COUNTA(B$17:B17)) Copy down as needed. -- Biff Microsoft Excel MVP "Paula" wrote in message ... I'm trying to automatically number rows that have been used, example if there is a number in B17 then in A17 is one, if there isn't a number in B18, leave bank and is a number in B19 then in A19 it would enter 2 -- -- Thanks so much--Paula |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to number only rows used --
Hi,
Put this in A1 and drag down as far as required. =IF(ISNUMBER(B1),COUNT($B$1:B1),"") "Paula" wrote: I'm trying to automatically number rows that have been used, example if there is a number in B17 then in A17 is one, if there isn't a number in B18, leave bank and is a number in B19 then in A19 it would enter 2 -- -- Thanks so much--Paula |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to number only rows used --
Hi Mike -- Wonderful!! worked perfect--
-- Thanks so much--Paula "Mike H" wrote: Hi, Put this in A1 and drag down as far as required. =IF(ISNUMBER(B1),COUNT($B$1:B1),"") "Paula" wrote: I'm trying to automatically number rows that have been used, example if there is a number in B17 then in A17 is one, if there isn't a number in B18, leave bank and is a number in B19 then in A19 it would enter 2 -- -- Thanks so much--Paula |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to number only rows used --
Glad I could help
"Paula" wrote: Hi Mike -- Wonderful!! worked perfect-- -- Thanks so much--Paula "Mike H" wrote: Hi, Put this in A1 and drag down as far as required. =IF(ISNUMBER(B1),COUNT($B$1:B1),"") "Paula" wrote: I'm trying to automatically number rows that have been used, example if there is a number in B17 then in A17 is one, if there isn't a number in B18, leave bank and is a number in B19 then in A19 it would enter 2 -- -- Thanks so much--Paula |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to number only rows used --
Thanks for the info -- This works also --
-- Thanks so much--Paula "T. Valko" wrote: Try this formula entered in A17: =IF(B17="","",COUNTA(B$17:B17)) Copy down as needed. -- Biff Microsoft Excel MVP "Paula" wrote in message ... I'm trying to automatically number rows that have been used, example if there is a number in B17 then in A17 is one, if there isn't a number in B18, leave bank and is a number in B19 then in A19 it would enter 2 -- -- Thanks so much--Paula |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to number only rows used --
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Paula" wrote in message ... Thanks for the info -- This works also -- -- Thanks so much--Paula "T. Valko" wrote: Try this formula entered in A17: =IF(B17="","",COUNTA(B$17:B17)) Copy down as needed. -- Biff Microsoft Excel MVP "Paula" wrote in message ... I'm trying to automatically number rows that have been used, example if there is a number in B17 then in A17 is one, if there isn't a number in B18, leave bank and is a number in B19 then in A19 it would enter 2 -- -- Thanks so much--Paula |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill Cells with same number in three rows then skip to next number | Excel Worksheet Functions | |||
Count number of rows, where non relevant rows are hidden | Excel Discussion (Misc queries) | |||
Get number of rows that data uses, including blank rows | Excel Discussion (Misc queries) | |||
Get number of rows that data takes up, including blank rows | Excel Worksheet Functions | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) |