Latest Date & Time

Hi All,

I have Date and Time in different columns. And would like to see whether that is latest in same category. I tried using MAXIFS but not able to get the result accurately as date and time are in diff columns.

Please find the attached set of data to be more clear on this.

Thanks,
Ravi C

Sorry, looking for Office 365. is there any other way ?

E3=IF($A3<>"",MAXIFS(B$3:B$15,$A$3:$A$15,$A3),"") copy across and down

Format column E as Date

Format column F as Time

Hi Olly,

That's great Working fine.

Thanks,
RC

Hi CARACALLA,

It doesn't look at Time at the same time. Instead of having so long i can also use only Maxifs.

Thanks,
RC

Hi Olly,

As it was increasing file size i just did change as below;

=MAXIFS($D:$D,$A:$A,A2)

where as D = B+C

Thanks,
Ravi C