cell reference to last item in a list
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 |
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 |
All times are GMT +1. The time now is 10:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com