Hi,

Example as followed:

Item Date updated Status Latest Status
A 23/6/2013 Green Blue
A 12/8/2013 Red Blue
A 23/8/2013 Blue Blue
B 13/8/2013 Yellow Black
B 23/8/2013 Black Black
B 23/2/2013 Purple Black

Basically will want Latest to return Blue for item A because that's the latest status based on the date.

Thanks.