HI There,
I am trying to figure out how to find my next available date based on a Vlookup criteria on a second tab.
See sample provided.
HI There,
I am trying to figure out how to find my next available date based on a Vlookup criteria on a second tab.
See sample provided.
Not sure what is "Earliest date" and "Next date", but in B13 is smallest date of Start date range and C13 is latest date of End Date range for single name:
B13:
=AGGREGATE(15,6,B$2:B$9/($A$2:$A$9=$A13),1)
C13:
=AGGREGATE(14,6,C$2:C$9/($A$2:$A$9=$A13),1)
Quang PT
HI There, thank you for responding. The formula for B13 gives me the correct answer for the Earliest date for Max. In C13, I am looking to find the next date for Max, from Column A as well. For example, the result will be 4/01/17 (B7)
See attachment
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks