Return latest date for Site

I would like to return the eaarlier date for a site.

Site Last date
AA 2014/01/06
AB 0
BB 0
CC 0
CD 0
DD 0

If Site AA, for example, then return the earlier date in a range. The range is in Sheet1. The earlier date for Site AA should be 2014/01/02 10:16. I have insert the attachment.

Site Employee Rep. Date
AA 1158 2014/01/02 10:16
AA 333 2014/01/03 12:35
AA 333 2014/01/03 09:35
AB 333 2014/01/02 13:03
AB 728 2014/01/02 11:28
BB 333 2014/01/03 11:47
CC 333 2014/01/03 14:37
CC 311 2014/01/04 08:58
CC 389 2014/01/01 14:09
CD 311 2014/01/06 08:49
CD 336 2014/01/04 11:28
DD 383 2014/01/06 14:00

hi,

Check the file for correctness .

Punnam

Hi bongielondy ,

Thanks for the reps. if u r questioned solved mark the thread as solved .

Punnam