Get the latest date but if there's blank the value should be blank

[anneb_87]

Hello World!

Can some help me?
How can I get the latest date on the following data?But if there's a blank date it should be blank.
I did the MAX IF for the latest date, I just don't know what to do on the condition if there's a blank date.

I would really appreciate your help!

Sample data:
client data received
client A 6/1/2018
client A 6/30/2018
client A 6/15/2018
client A
client A 6/5/2018
client B 6/20/2018
client B 6/12/2018
client B 6/1/2018
client B 6/5/2018

Expected output should be:
client data received
Client A
Client B 6/20/2018

 

[anneb_87]

This one also works.

{=IF(COUNTIFS($A$2:$A$10,$A13,$B$2:$B$10,""),>0"",MAX(IF(
$A$2:$A$10=A13,$A13,$B$2:$B$10)))

My previous mistake was I have entered " between the MAXIF function.

THANKS EVERYONE!! Such a great help!!??

 

[Aladin Akyurek]

@Aladin Akyurek
I have notice that the formula you have given for MAXIFS and AGGREGATE are the same. What should be the correct formula for AGGREGATE?

It is:

=IF(COUNTIFS($A$2:$A$10,$A13,$B$2:$B$10,"="),"",AGGREGATE(14,6,$B$2:$B$10/($A$2:$A$10=$A13),1))

 

[jtakw]

You're welcome, welcome to the forum.

Yes, looks like you just had the quotes around your MAX/IF portion of the formula in Post #3 causing problems, glad you worked it out.

EDIT: It's probably a typo, but you have a misplaced comma in Post #11 , the comma in Front of > should go After the 0 (between 0 and "") 0,""

 

[anneb_87]

Thank you!!! ???

 

[btorrean]

No problem @anneb_87! Happy to help (if I did).

Brian