Numbered rows...

**tancuda** · 03-21-2010, 08:19 AM

Hi

I would like to get numbered rows depending on a value entered in a cell,
let's say that value is 10, so I want A1 to be 1, A2 to be 2, thru 10.

Thanks in advance.

**martindwilson** · 03-21-2010, 08:47 AM

put this in any cell you want to start from and drag down then put value in d1
=IF(ROWS($A$1:A1)>$D$1,"",ROWS($A$1:A1))

**tancuda** · 03-22-2010, 07:55 PM

Thanks for the answer, but I don't want to drag down to get the numbers,
I want them to light up automaticaly.

**martindwilson** · 03-22-2010, 08:12 PM

what do you want then?
harry potter magic?
i suppose you could use code tho'

**tancuda** · 03-22-2010, 09:16 PM

Originally Posted by tancuda

Thanks for the answer, but I don't want to drag down to get the numbers,
I want them to light up automaticaly.

Sorry for that reply and my english, "light up" wasn't the good expression to use I think !
I'm learning...I'm learning.....

But I did run your formula again, and tha'ts good, I have to translate
the formula in french, it's not that evident. Now I like it.

Any idea where I can find Excel formulas in english and french ?

Thanks anyway.