+ Reply to Thread
Results 1 to 6 of 6

Count Unique Values in Different Columns

  1. #1
    Registered User
    Join Date
    04-08-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    69

    Count Unique Values in Different Columns

    Greetings! I'm trying to count the number of unique rows, based off of the value in a completely different column. Attached is an example of what I'm working with. I'm essentially wanting to count the number of unique account numbers (Column A in 'Customer' tab), and unique customer numbers (Column B in 'Customer' tab), based off of the criteria that's in Column C in 'Customer' tab. Test File - Unique Counts.xlsx
    Last edited by dash11; 06-25-2018 at 03:00 PM. Reason: Add Attachment

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,359

    Re: Count Unique Values in Different Columns

    =SUMPRODUCT(--(FREQUENCY(IF(Customer!C$2:C$1308=$C4,Customer!$A$2:$A$1308,""),IF(Customer!C$2:C$1308=$C4,Customer!$A$2:$A$1308,""))>0)), CSE

  3. #3
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,874

    Re: Count Unique Values in Different Columns

    Try these:

    D4 =COUNTIF(Customer!C:C,C4)
    There are no duplicate account numbers

    E4 =SUMPRODUCT((Customer!C$2:C$1308=C4)/COUNTIF(Customer!B$2:B$1308,Customer!B$2:B$1308&""))

    Drag both formulas down.

  4. #4
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    2,888

    Re: Count Unique Values in Different Columns

    In "D4"
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    In "E4"
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    press Ctrl + Shift + Enter keys together


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  5. #5
    Registered User
    Join Date
    04-08-2011
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    69

    Re: Count Unique Values in Different Columns

    This formula/function worked perfect, thank you! I definitely learned something new today

  6. #6
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,874

    Re: Count Unique Values in Different Columns

    You had 3 responses. I'm not sure which one you are referring to but glad we could help.

+ 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. Count unique values across 3 columns
    By maym in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 07-23-2015, 09:19 PM
  2. [SOLVED] Find count of Unique or Duplicate Values based on Concatenated values in 2 columns
    By bdicarlo1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-03-2014, 12:42 AM
  3. [SOLVED] Count unique values only, over two columns in the same row
    By matrixpom in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-23-2014, 08:42 AM
  4. Count Unique values in Column based on values in other columns
    By dmschave in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-17-2014, 11:06 AM
  5. Replies: 16
    Last Post: 01-11-2012, 10:51 AM
  6. count unique values in columns based on date values
    By cclntn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-29-2010, 06:16 PM
  7. Count values where unique in both columns
    By krabople in forum Excel General
    Replies: 2
    Last Post: 06-24-2009, 06:08 AM

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