Find row number

[SIGE]

Hi There,

1.
Is there a way that I can determine the row number in which TOTAL is
written?
The range in Column A changes from sheet to sheet...
eg.
Shee1:
-in Column A thereare several items: a,b,c,d,... and underneath there
is "Total"
I would like to determine in eg B2 on which row number i can find
"Total"

Sheet2:
- items in Column A : a,b,c,d,e,f,....z,Total ...hoow to give the row
number in B2 again


2.
-Returning the row number of the last filled cell in column A might be
an alternative...

Cheers Sige

 

[Jerry W. Lewis]

=MATCH("Total",A1:A100,0)

Jerry