If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 How to number only rows used --
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## How to number only rows used --

#1
September 15th 09, 05:12 PM posted to microsoft.public.excel.misc
 Paula external usenet poster 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
 T. Valko external usenet poster 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
 Mike H external usenet poster 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
 Paula external usenet poster 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
 Mike H external usenet poster 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
 Paula external usenet poster 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
 T. Valko external usenet poster 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

>>
>>
>>

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post Fill Cells with same number in three rows then skip to next number Tracy Excel Worksheet Functions 2 November 7th 08 03:12 PM Count number of rows, where non relevant rows are hidden Pieter Excel Discussion (Misc queries) 2 November 8th 06 12:24 PM Get number of rows that data uses, including blank rows Denham Coote Excel Discussion (Misc queries) 5 August 22nd 06 02:10 PM Get number of rows that data takes up, including blank rows Denham Coote Excel Worksheet Functions 2 August 21st 06 09:18 AM flexible paste rows function that inserts the right number of rows marika1981 Excel Discussion (Misc queries) 1 February 18th 05 02:40 AM

All times are GMT +1. The time now is 01:06 AM.