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: |
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. |
All times are GMT +1. The time now is 10:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com