+ Reply to Thread
Results 1 to 5 of 5

How to count unique records in a column?

  1. 06-21-2018, 02:25 PM #1
    Rev12
    Rev12 is offline
    Registered User
    Join Date
    04-14-2014
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    97

    How to count unique records in a column?

    Hi everyone!

    I wanted to count a unique records that are duplicated in a column,

    I have attached my excel for your ease of manipulation.

    Thanks in advance for any help

    Rev12
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-21-2018, 02:28 PM #2
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.96 for Mac MS 365
    Posts
    8,691

    Re: How to count unique records in a column?

    this would be one way... =IF(COUNTIF($A$2:A2,A2)=1,1,"")
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci
    Reply With QuoteRegister To Reply
  3. 06-21-2018, 02:28 PM #3
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: How to count unique records in a column?

    one way PivotTable & DataModel
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 06-21-2018, 03:02 PM #4
    Rev12
    Rev12 is offline
    Registered User
    Join Date
    04-14-2014
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    97

    Re: How to count unique records in a column?

    Thanks Sambo Kid it works as the way I wanted to
    Reply With QuoteRegister To Reply
  5. 06-21-2018, 03:03 PM #5
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.96 for Mac MS 365
    Posts
    8,691

    Re: How to count unique records in a column?

    Glad that did it for you, AND thank you for the rep!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] count unique records in one column based on criteria in a different column
    By rxg2669 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-10-2015, 12:38 AM
  2. [SOLVED] VBA to show the count of unique records
    By muralidaran in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-30-2014, 04:03 PM
  3. Count Unique records
    By guido167 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-23-2013, 03:08 PM
  4. Count unique records in a column
    By bcn1988 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-20-2013, 11:51 AM
  5. [SOLVED] Vlookup and Count Unique Records in adjacent column
    By gjohn282 in forum Excel General
    Replies: 3
    Last Post: 06-26-2012, 02:17 AM
  6. Excel 2007 : Count Unique Records
    By stevetothink in forum Excel General
    Replies: 2
    Last Post: 11-04-2011, 04:22 PM
  7. Formula to count unique number of records in a column
    By stats09 in forum Excel General
    Replies: 3
    Last Post: 03-22-2010, 10:15 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1