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
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