software

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

=MIN(IF(B2:B200=quot;smithquot;,C2:C200))

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Robertquot; gt; wrote in message
...
gt; Hi -
gt;
gt; I have a list of names. (40 Different names that may occur 30 - 40 times
a
gt; piece in column B). In Column C I have a list of times that each person
made
gt; an entry. Is there a formula that will give me the earliest time that
gt; appears in column C for each person on the list in column B? I already
have
gt; a list of all of the unique names that will appear in column B that I can
use
gt; as a reference.
gt;
gt; Example:
gt;
gt; col A col B col C
gt; smith 6:00am
gt; jones 5:03pm
gt; smith 7:05am
gt; jones 4:02pm
gt; adams 2:05pm
gt; adams 2:33pm
gt;
gt; RESULT I WANT
gt;
gt; adams 2:05pm
gt; jones 4:02pm
gt; smith 6:00am
gt;
gt;
gt;
gt; --
gt; Robert