Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Cell Reference Math | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
name of another worksheet in cell for reference | Excel Worksheet Functions | |||
Place a set value in a cell from a drop down list name reference | Excel Worksheet Functions |