+ Reply to Thread
Results 1 to 3 of 3

Find/Within Formula

  1. #1
    Registered User
    Join Date
    06-12-2011
    Location
    Denver
    MS-Off Ver
    Excel 2007
    Posts
    1

    Find/Within Formula

    Hi everyone, I've been a long time lurker, but this is my first post.

    I have this formula I'm looking for, but can't seem to crack - it's stumped me and I hope someone here can help.

    I'm doing a scheduling project where I have set up 1/2 increments as the column headings, I have job titles as my row headings and I input a persons name in the data section for the units they work.

    I'm trying to summarize start times for the day and am trying to set up a formula that will return the top row (start time) for the person.

    So, the chart would look like this:

    - Column A Column B Column C
    Row 1 1/2 hour units 7:30 AM 8:00 AM
    Row 2 Clerk 1 Bob Steve
    Row 3 Clerk 2 Joe Tom

    I'm trying to create a formula that says: if Tom is in Column B, then return B1. In this case the answer would ne "null" because Tom is in Column C. But if I wrote the formula for Joe in Column B, the answer would be "7:30 AM".

    I just can't figure this one out.

    Thanks for your help.

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    Kuwait
    MS-Off Ver
    Office 365
    Posts
    2,199

    Re: Find/Within Formula

    Hello brandon722, Welcome to the forum!

    It looks like ISNUMBER/MATCH would do it, but wonder should be something else you are looking, Please attach a dummy file with expecting result.
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Find/Within Formula

    A simplistic answer to your question would be:

    =IF(COUNTIF(B:B,"Tom"),B1,"null")

    replace the use of "Tom" with the address of a cell that holds the name you want to check.

+ 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