+ Reply to Thread
Results 1 to 2 of 2

Count unique text from multiple columns concatenated w/ one column

  1. #1
    Registered User
    Join Date
    06-30-2011
    Location
    Livermore, CA, US
    MS-Off Ver
    Excel 2010
    Posts
    3

    Count unique text from multiple columns concatenated w/ one column

    10-1-2015 3-39-21 PM.png
    My data looks something like (assume begins in A1):
    Category,Label1,Label2
    Dogs,blank,doe
    Dogs,zoo,blank
    Cats,zoo,yup
    Cats,doe,hgg
    Cats,blank,doe

    This function works for count of overall unique labels in cols B & C
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Result: 4

    But I want the following so that I can include col A in the evaluation.
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    the result would then be: 6

    The problem is countif doesn't seem to like the concatenated ranges in its first argument. Is there a way to fix this?


    BTW I am looking at this as an intermediate solution. What I really want to do is this: http://www.excelforum.com/excel-form...ml#post4204459

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,420

    Re: Count unique text from multiple columns concatenated w/ one column

    In the file attached I used the formula:
    Please Login or Register  to view this content.
    in F6 and dragged it down to F7.

    Count unique labels by category.xlsx

    Let me know if you have any questions.

+ 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. Need unique count of text from multiple columns by category
    By lopez235 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-01-2015, 11:26 AM
  2. Replies: 6
    Last Post: 08-19-2015, 07:46 PM
  3. [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
  4. [SOLVED] Sort and Count Unique List Across Multiple Columns - Student Count
    By BuntyMac in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 08-17-2014, 07:00 AM
  5. Finding Unique Count for a Concatenated Range of Columns.
    By e4excel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-12-2012, 06:30 AM
  6. Replies: 11
    Last Post: 06-09-2011, 03:17 PM
  7. Replies: 5
    Last Post: 04-21-2011, 05:22 PM

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