+ Reply to Thread
Results 1 to 4 of 4

COUNTIF to identify non-repeat values

  1. #1
    Registered User
    Join Date
    12-07-2010
    Location
    Atlanta, Georgia
    MS-Off Ver
    Excel 2003
    Posts
    21

    COUNTIF to identify non-repeat values

    Hello,

    I need a clean COUNTIF formula to identify if a set of values across a row do not occur again in columns if they have a specific condition.

    If Column E = "Accepted" and Last Name & First Name do not occur again, then Column F should indicate "Open Case"

    Thanks for your help.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: COUNTIF to identify non-repeat values

    Try this in G2 and copy down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Sincerely
    S?ren Larsen

    "Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"

  3. #3
    Registered User
    Join Date
    12-07-2010
    Location
    Atlanta, Georgia
    MS-Off Ver
    Excel 2003
    Posts
    21

    Re: COUNTIF to identify non-repeat values

    Excellent Soren....worked perfectly. Thanks!

  4. #4
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: COUNTIF to identify non-repeat values

    You're very welcome; don't forget to mark your thread as solved...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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