Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I skip first the first occurence in an index search?
During an index search my first occurence is always blank.
Is there a way to modify thise formula to skip the first occurence and check for the second as the second occurence always contain the figure. Currently there is no way to remove the first occurence. =INDEX(Info!$A$1:$H$101, MATCH(B15,Info!$F$1:$F$101,), MATCH("Total",Info!$A$1:$H$1,)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
next occurence | Excel Worksheet Functions | |||
search for Index+average in threads | Excel Worksheet Functions | |||
Occurence #'s | Excel Discussion (Misc queries) | |||
How to use an index number in a search range | Excel Worksheet Functions | |||
Using Search with either vlookup or match and index | Excel Worksheet Functions |