Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
search a column for last instance of text
hi, trying to find way to locate text "up" from current position. not sure
which function / how to use. have been looking at: MATCH, LOOKUP.. thanks example have for find last number in a column is: =P54=LOOKUP(9.99999999999999E+307,P$24:P$59) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search for first instance of text & return the value | Excel Worksheet Functions | |||
URGENT: Search for text in column and count by month | Excel Discussion (Misc queries) | |||
Fast way to search many cells by column for text strings | Excel Discussion (Misc queries) | |||
Search a Column by text length | Excel Worksheet Functions | |||
Search column and move text formula | Excel Discussion (Misc queries) |