Display latest status in Final Status column after comparing the status on three dates

[shekharnyk]

Want to display the latest status in Final Status column after comparing the status on three different dates. Please find the attached file. Thanks in advance.

Final Status Status 1 Date 1 Status 2 Date 2 Status 3 Date 3
Pass 4/1/2012 Fail 4/3/2012 Fail 4/6/2012

[jraj1106]

Hi
Can you provide proper sample data?

[shekharnyk]

Example file uploaded

[Haseeb Avarakkan]

Try...

Please Login or Register  to view this content.

[shekharnyk]

Thanks for the help. this exactly what i wanted.