Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding Next Occurrence
I download each morning off the web information that is download as an
Excel document. Well right now, I am trying to get the "Index and match" function to work. It works on the very first occurrence of an item, but I cannot seem to figure out how to make it work in every occurrence. Sometimes my first criteria will not even appear on that day's information, and sometimes there could be as many as five appearances. Therefore, what I am trying to do in my "Index and Match" formula is locate the first occurrence and my first, and then if any others appear extract them as well. Now they will always appear, if they appear for that on line 14, of the download. He is the formula that I am presently using: {=INDEX('[CBHI-0129.xls]Sheet1'!$L$2:$L$100,MATCH(1,($I $27='[CBHI-0129.xls]Sheet1'!$J$2:$J $100)*("Data"='[CBHI-0129.xls]Sheet1'!$H$2:$H$100),0))} Where I27 is what I am trying to match to in CBHI-0129, and this is what could occur or could not occur, each day. In CBHI-0129 column H, there can be the word Total or Data, all intermingled. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup on first occurrence of X after Y? | Excel Worksheet Functions | |||
Max value for each day, and hour of that occurrence | Excel Discussion (Misc queries) | |||
Finding the most/least/average occurrence(appear) number? | Excel Discussion (Misc queries) | |||
find last occurrence | Excel Worksheet Functions | |||
Max number of Occurrence | Excel Worksheet Functions |