row number in cell Excel

[ts04]

Hi Everybody,

I would like to know how I can have a cell discplay the row number that belongs to a specific cell in my ecxel sheet.

Using Office 2000

Thanks in advance!

Tanja

 

[Loomah]

=row(a1)
or for the row you are in just
=row()

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​