Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find 2nd occurence
Hi all,
I have a row of dates like this: 10.03.2008 10.26.2008 11.16.2008 11.17.2008 12.16.2008 01.08.2009 ...... on the same sheet there is a table with dates intervals like this one: Time Interval Code 01.07.2008 - 03.19.2008 A 03.06.2008 - 03.18.2008 B 03.14.2008 - 06.30.2008 C 05.24.2008 - 09.12.2008 D 09.13.2008 - 11.17.2008 E .... I was trying to find the first occurence of the dates from A:A in the table of time intervals and get the code and actually i did, with this formula in B:B : =INDEX($J$3:$J$15,MATCH(1,((A2$K$3:$K$15)*(A2<$L$ 3:$L$15)),0)) and it works great, Now i am trying to expand the formula to find the second occurence (put it in C:C) different than the first one found in (B:B) and i got stuck, i just cant see it, i am thinking that something should be done inside my MATCH so to speak "start from where you stopped in B:B", can this be done? or otherwise any ides on how to approach it in an other way? Thanks . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find the row number of name occurence | Excel Worksheet Functions | |||
Find Last Occurence in a Range with VBA | Excel Discussion (Misc queries) | |||
Find first occurence of a number in an array 7 cols wide | Excel Worksheet Functions | |||
Trying to FIND lowercase or uppercase of target occurence | Excel Worksheet Functions | |||
Find first occurence in a list that's greater than a specific num | Excel Worksheet Functions |