Hi,
I'm trying to find how can I look a date..... in range of dates in column A, then say which date has lower value in B.
Thanks
Reference of date in L3 to look in column A --> 10/27/2014
Criteria:
1) Identify how many dates in column A are EQUAL or GREATER to value in L3 (see in yellow)
2) Then, from the dates found in column A, say which has the LOWER value in column B (see in yellow)
The result of criteria 1) and 2) has to show the number of the ROW in L10 --> 9
COLUMN A COLUMN
10/14/2014 10
10/15/2014 11
10/15/2014 12
10/15/2014 13
10/16/2014 14
10/17/2014 15
10/17/2014 16
10/21/2014 17
10/28/2014 18
10/27/2014 19
10/22/2014 20
10/23/2014 21
10/27/2014 22
10/24/2014 23
Bookmarks