Remember Me?

#1
September 15th 09, 05:12 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 138
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
September 15th 09, 05:18 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 15,768
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
September 15th 09, 05:19 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Apr 2007 Posts: 11,501
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
September 15th 09, 05:29 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 138
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
September 15th 09, 05:45 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Apr 2007 Posts: 11,501
How to number only rows used --

"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
September 15th 09, 06:08 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 138
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
September 15th 09, 06:34 PM posted to microsoft.public.excel.misc
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 15,768
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Tracy Excel Worksheet Functions 2 November 7th 08 04:12 PM Pieter Excel Discussion (Misc queries) 2 November 8th 06 01:24 PM Denham Coote Excel Discussion (Misc queries) 5 August 22nd 06 02:10 PM Denham Coote Excel Worksheet Functions 2 August 21st 06 09:18 AM marika1981 Excel Discussion (Misc queries) 1 February 18th 05 03:40 AM

All times are GMT +1. The time now is 08:13 AM.