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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=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)
 
Back
Top