Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup with a bizarre twist
In each cell of column B (rows 3 to 150), there is either nothing (Null) or
an asterisk. All the asterisked cells will be in consecutive rows - but where they start and finish is variable depending on other calculations in the worksheet. I want to be able to find the top and bottom row that has an asterisk in it and return the corresponding cell values in column A. eg a b c * d * e * f * g h I'd be looking for two formulae - one to identify 'c' as the top value and 'f' as the bottom value. Can SKS help. Many thanks in advance. Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Problem | Excel Worksheet Functions | |||
Index table lookup anomaly | Excel Worksheet Functions | |||
Excel Lookup Functions | Excel Worksheet Functions | |||
Another Lookup function, please | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |