| 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 |
|
#2
|
|||
|
|||
|
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 |
| 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 | |||
Linear Mode
