+ Reply to Thread
Results 1 to 9 of 9

If Unique then formula

  1. #1
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,689

    If Unique then formula

    Hi

    Can anyone help with a formula please.

    In column J I have a list of users. In column W I would like a formula which would place a “1” in the cell if the user is unique and zero if not.

    Can anyone help please?

    Paul
    Attached Files Attached Files

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: If Unique then formula

    try

    =IF(COUNTIFS($J$4:$J$25924,J4)>1,0,1) and drag down!!!
    Last edited by shukla.ankur281190; 08-24-2016 at 08:34 AM. Reason: Missing info
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: If Unique then formula

    Here:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,892

    Re: If Unique then formula

    Or ...

    =--(COUNTIF($J$4:J4,J4)=1)

  5. #5
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,892

    Re: If Unique then formula

    Quote Originally Posted by zbor View Post
    Here:
    =IF(COUNTIF($J$4:$J$65000, J5)=1, 1, 0)
    Maybe like this ...

    --(COUNTIF($J$4:$J$65000, J5)=1)

  6. #6
    Registered User
    Join Date
    06-17-2015
    Location
    Portland, TX
    MS-Off Ver
    2013
    Posts
    1

    Re: If Unique then formula

    i have the same question

  7. #7
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,689

    Re: If Unique then formula

    Hi

    None of these worked but I managed to adapt one slightly to make it work, =IF(COUNTIF($J$4:$J4, J4)=1, 1, 0)

  8. #8
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: If Unique then formula

    It's a solution that Phuocam in post #4 so his should work.

    I would rather suggest you next time: instead of thousand examples of input and none of output to create several input values and desired output values.
    That will bring you solution faster.

  9. #9
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,689

    Re: If Unique then formula

    Ah so it was!

    Will do - I normally do but will take your recommendation on board for next time

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Help with formula for unique values - VBA
    By rkohman in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-19-2016, 11:46 AM
  2. Formula to count unique possible?
    By calvinle in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-08-2016, 07:49 PM
  3. Replies: 6
    Last Post: 01-17-2016, 09:44 AM
  4. Unique formula that also counts non-unique once
    By jvbeats in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-19-2013, 02:38 PM
  5. Formula for unique dates
    By misterzr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-28-2010, 10:54 AM
  6. Formula for next unique value
    By ninja0059 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-30-2009, 04:04 PM
  7. [SOLVED] Add a unique formula
    By trainer07 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-03-2005, 09:45 PM

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