Find a time value in one column based on names in another
 

Hi -

I have a list of names. (40 Different names that may occur 30 - 40 times a
piece in column B). In Column C I have a list of times that each person made
an entry. Is there a formula that will give me the earliest time that
appears in column C for each person on the list in column B? I already have
a list of all of the unique names that will appear in column B that I can use
as a reference.

Example:

col A col B col C
smith 6:00am
jones 5:03pm
smith 7:05am
jones 4:02pm
adams 2:05pm
adams 2:33pm

RESULT I WANT

adams 2:05pm
jones 4:02pm
smith 6:00am



--
Robert

Find a time value in one column based on names in another
 

=MIN(IF(B2:B200="smith",C2:C200))

as an array formula, so commit with Ctrl-Shift-Enter

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Robert" wrote in message
...
Hi -

I have a list of names. (40 Different names that may occur 30 - 40 times
a
piece in column B). In Column C I have a list of times that each person
made
an entry. Is there a formula that will give me the earliest time that
appears in column C for each person on the list in column B? I already
have
a list of all of the unique names that will appear in column B that I can
use
as a reference.

Example:

col A col B col C
smith 6:00am
jones 5:03pm
smith 7:05am
jones 4:02pm
adams 2:05pm
adams 2:33pm

RESULT I WANT

adams 2:05pm
jones 4:02pm
smith 6:00am



--
Robert