+ Reply to Thread
Results 1 to 3 of 3

True/False Duplicate Formula

  1. #1
    Registered User
    Join Date
    04-07-2014
    Location
    Knoxville, TN
    MS-Off Ver
    Excel 2007
    Posts
    37

    True/False Duplicate Formula

    I have a list of numbers in column A. In column be i need a true/false formula to tell me if the number listed in column a is a duplicate.

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: True/False Duplicate Formula

    Would you only want the 2nd+ occuarance of the duplicate to be true?
    Or should the first occurance of the duplicate also be true?

    If the first occurance of the duplicate should be FALSE, try this in B1 and filled down.

    =COUNTIF(A$1:A1,A1)>1

  3. #3
    Valued Forum Contributor
    Join Date
    08-04-2011
    Location
    UK
    MS-Off Ver
    Excel 2021
    Posts
    346

    Re: True/False Duplicate Formula

    in B1 and copy down

    =IF(COUNTIF(A:A,A1)>1,TRUE,FALSE)

+ 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. Help with TRUE/FALSE formula
    By mikkelno in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-28-2014, 12:31 PM
  2. [SOLVED] True False ( need duplicate not duplicate )
    By makinmomb in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-07-2014, 03:49 AM
  3. What is best to use for helper cells 0 or 1, typed true or false or =true =false
    By Gingermuppet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2014, 10:41 PM
  4. [SOLVED] in this TRUE OR FALSE function, i want desired name instead of display true or false
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-15-2013, 06:44 PM
  5. Excel 2007 : If formula using True and False
    By casdaq in forum Excel General
    Replies: 2
    Last Post: 05-06-2011, 03:59 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