This will give you the row number counted starting with row 1

=MAX(IF(A1:A2000=C1,ROW(A1:A2000)))

where C1 holds the costcenter name/number/string


It needs to be entered with ctrl + shift & enter


=CELL("address",INDEX(A1:A2000,MAX(IF(A1:A2000=C1, ROW(A1:A2000)))))

also entered the same way


will give you the absolute cell reference

--


Regards,


Peo Sjoblom



"QuietMan" wrote in message
...
Thanks, but dosen't help me find the last instance...any ideas on that
--
Helping Is always a good thing


"Pete_UK" wrote:

The MATCH function will return the relative position of a cell within
a range which matches another cell, eg:

=MATCH(sought_value,range,0)

where range can be a full-column reference, eg D:D, and sought_value
can be a specific value or a reference to a cell which contains that
value (your cost centre). If your range is, for example, D10:D24, then
you will have to add 9 onto the result to get the actual row number of
the matched item.

Hope this helps.

Pete

On Aug 14, 12:15 am, QuietMan
wrote:
Can someone help....I need to know if there is a function in excel that
can
look through a column of data, find a specific cost center and return
the
first instance/row that costcenter shows and also the last instance/row

Thanks
--
Helping Is always a good thing