Maximum date to pick from the data

[sriku]

Hi,

There are around 5000 line items in the data. I want to know output pay date based on the event ID. when I put pivot the out put should be like shown in pivot sheet.

Please help me with the formula.

Thanks,
Sriku

[Ace_XL]

In row 4

=MAX(INDEX((Data!$A$2:$A$26=A4)*Data!$F$2:$F$26,0),0)

Copy down

[sriku]

Hi,

when I apply this formula in the pivot the date format shows as 1/0/1900. Even though I format the date it is not happening.

Please help.