+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Robert
    Guest

    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. #2
    Bob Phillips
    Guest

    Re: 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" <Robert@discussions.microsoft.com> wrote in message
    news:EF23C173-6116-4FFF-98CC-F3E400EE1BE4@microsoft.com...
    > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1