cell reference to last item in a list

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

How do I create a formula that will give me the last or
first cell in a column that contains a particular value -
for instance if my column is

A1: X
A2: Y
A3: Y
A4: Z

then what formulas will give me the results A2 or A3
for "Y"

Thx
Lee
 
Back
Top