Thread
:
cell reference to last item in a list
View Single Post
#
2
Don Guillett
Posts: n/a
Have a look in HELP index for MATCH. Read the different 1, -1, 0
--
Don Guillett
SalesAid Software
"Lee" wrote in message
...
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
Reply With Quote