Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I NEED HELP
I need help figuring out what formula to use if I have an ID# and a date that falls within a range what is the date that corresponds to both those criteria
ID DATE RANGE Date 1956 11/29/2012 2/28/2013 1/13/2013 3000 11/29/2012 2/28/2013 1/13/2013 37999 11/29/2012 2/28/2013 1/13/2013 3609 11/29/2012 2/28/2013 1/13/2013 20057 11/29/2012 2/28/2013 1/13/2013 4140 11/30/2012 3/1/2013 1/14/2013 4143 11/30/2012 3/1/2013 1/14/2013 # 3000 Date 12/2/2012 Response: |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I NEED HELP
=IF(AND(B11INDEX(A2:D8;MATCH(B10;A2:A8;0);2);B11< INDEX(A2:D8;MATCH(B10;A2:A8;0);3));INDEX(A2:D8;MAT CH(B10;A2:A8;0);4);0)
column A = ID# column B = first date of date range column C = last date of date range column D = return date cell B10 = ID# cell B11 = Date Hope this helps. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|