CODEWITHSUNDEEP
excelexcel-formulamaxexcel-2010worksheet-function
poshan
poshan

Reputation: 3287

How to use MAX function with a condition?

I would like to generate data as shown in the below table. I would like to use a MAX function on column MaxDate so that it pulls the most recent date from the Date column. I would like to have the most recent date in one cell per client just like as shown. I would appreciate any suggestion.

enter image description here

Upvotes: 0

Views: 136

Answers (1)

pnuts
pnuts

Reputation: 59495

If Date is in A1, please try in D2 and copied down: 

=IF(C1<>C2,MAX(IF(C2:C11=C2,A2:A11)),"")

Upvotes: 1

Related Questions