Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change date based on time | Excel Discussion (Misc queries) | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
Count cells based on date range in another column | New Users to Excel |