If your Data is sorted, then you could look up the first value of
Tommy and
that would be the lowest date.

Sort your Data first after Column B, than Column A.

Then, in order that VLookup works, you need to have
your lookup field in the first column, so either change column
b and a or copy column a into column c which you can hide.

then put a vlookup formula in a cell you want.

hth

Carlo

On Dec 10, 10:49 am, Freshman
wrote:
Dear experts,

I've rows of records which column A is for dates and column E is for
saleman's names:

1 Aug 2007 Tommy
15 Aug 2007 Tommy
26 Sep 2007 Tommy
4 July 2007 Peter
25 Sep 2007 Peter
18 Nov 2007 Peter

Is there a function which can filter out the earliest date for Tommy,
Peter....etc.
Please advise.

Thanks & regards.