Plotting time by formula by given date from old (Outdated) to new (Latest)

Hello Friends

Version : MS Excel 2010
Attached file : Display Text Entries according to Latest Time and date2.xlsx

Please find the attached file, my requirement is i want to plot the time in Column E (Yellow cells)
by formula for the given date in Column D cells and looking in Column A & B (Column A for Date & Column B for Time).

Note : Some dates repeated and this should be taken care in formula.



thanks in advance

thilag

Maybe:

For Date:
=INDEX($A$2:$A$49,MATCH(SMALL(COUNTIF($A$2:$A$49,"<"&$A$2:$A$49),ROW(1:1)),COUNTIF($A$2:$A$49,"<"&$A$2:$A$49),0))

For Time:
=INDEX($B$2:$B$49,MATCH(LARGE((COUNTIF($B$2:$B$49,">"&$B$2:$B$49)*($A$2:$A$49=$D2)),COUNTIF($D$2:D2,D2)),COUNTIF($B$2:$B$49,">"&$B$2:$B$49),0))

All is Array Formulas
Cheers

Hello Azumi

Perfect Thanks

thilag

Take care, thanks for feedback

Cheers