+ Reply to Thread
Results 1 to 2 of 2

IF AND statement based on condition of another cell

  1. #1
    Forum Contributor
    Join Date
    02-24-2011
    Location
    Los Angeles, CA
    MS-Off Ver
    Office 2010
    Posts
    164

    IF AND statement based on condition of another cell

    Help... I can't figure this out and have been trying for 2 days....

    What I'm trying to do is look at three columns of information. If the "Date Worked" and "Name" columns are the same and if the "Time Type" columns has the "SB" which appears more than once for that given Date Worked and Name, then it would show as a duplicate. If there isn't a duplicate for the Date worked and name, it would then show as OK.

    Untitled-1.jpg

    Column N is Date worked in image.

    The formula I have right now is
    =IF(Q3="SB",IF(AND(N3=N2,O3=O2),"Duplicate","OK"))

    We use to filter out all other Time Types, except for "SB" and were using this function
    =IF(AND(N3=N2,O3=O2),"Duplicate","OK") - It worked perfectly. However, we're trying to verify multiple additional types of information which now includes multiple Time Types, and this will no longer work.
    I probably going about this completely wrong and there is probably an easier way to do this, so any information or assistance would be greatly appreciated.
    Last edited by Delta729; 02-24-2011 at 09:29 PM.

  2. #2
    Forum Contributor
    Join Date
    02-24-2011
    Location
    Los Angeles, CA
    MS-Off Ver
    Office 2010
    Posts
    164

    Re: IF AND statement based on condition of another cell

    Hi, thanks for the reply.

    That gives me a "duplicate" response every time the Time Type shows SB and not if there are duplicate SB's for the given date and name.

    EDIT: I figured it out....

    =IF(AND(Q3="SB",Q2="SB"),IF(AND(N3=N2,O3=O2),"Duplicate"),"OK")
    Thanks JFP, revised your formula and made it an IF AND

    Works perfectly.
    Last edited by Delta729; 02-25-2011 at 01:27 PM.

+ 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