Report latest date

[Kay2556]

Hi,

I have a file (attached sample) where columns J to K contain information imported from another source. I have managed to get all dates showing for each ID in columns D to H, with the latest date in bold. Blanks currently show as 00/01/1900 in columns (D to H).

How do I then get the latest date showing in column B without manually changing it I have tried various combination formulas but no success. I need the outcome to show either the latest date, N/A or if blank '-' a hyphen.

Thanks.
K

 

[vletm]

Something like this?

 

[bosco_yip]

Expiry Date without helper columns formula way.

In D2, formula copy down :

=IFERROR(LOOKUP(9^9,K$2:K$20/(J$2:J$20=A2)/(K$2:K$20>0)),"-")

Regards
Bosco

 

[Kay2556]

Something like this?

That's it, thank you works perfectly.