Hi,

Try:

=MAX(IF(Sheet1!A1:A100="john",Sheet1!B1:B100))
or assuming A1 is the cell the name "John" then
=MAX(IF(Sheet1!A1:A100=A1,Sheet1!B1:B100))
enter using Ctrl+Shift+Enter

HTH
Jean-Guy


" wrote:

Hello my friends.

I have 2 columns of data in Excel. Column A is a list of names, all the
names have more than one entry. Column B is filled with various dates.
I want to use the data on this sheet to populate a cell on another
sheet with the oldest date in column B for any selected name.

I know the SMALL function will have to be in there somewhere, but this
one has got me beat. Any ideas out there?