LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 51
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find the row number of name occurence [email protected] Excel Worksheet Functions 9 October 3rd 08 08:34 AM
Find Last Occurence in a Range with VBA jlclyde Excel Discussion (Misc queries) 2 October 1st 08 07:04 PM
Find first occurence of a number in an array 7 cols wide Ricardo-SA Excel Worksheet Functions 3 April 5th 08 11:22 PM
Trying to FIND lowercase or uppercase of target occurence u473 Excel Worksheet Functions 3 August 23rd 07 11:08 PM
Find first occurence in a list that's greater than a specific num stevep Excel Worksheet Functions 2 December 9th 05 08:41 PM


All times are GMT +1. The time now is 04:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"