+ Reply to Thread
Results 1 to 4 of 4

Count unique data across multiple columns

  1. #1
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2010, 2016
    Posts
    1,173

    Count unique data across multiple columns

    I'm trying to count the number occurrences for each unique item across multiple columns. For example, I have following data across columns A, B, & C. It is a two-step process (1) figure out the unique items from all three columns as the data changes every day (2) count the number of occurrences for each unique item.

    Column A
    Apple
    Orange
    Pear
    Grape
    Carrot
    Kiwi

    Column B
    Pear
    Grape
    Watermelon
    Egg

    Column C
    Egg
    Apple
    Grape
    Peanut

    My desired output would be:
    Apple 2
    Orange 1
    Pear 2
    Grape 3
    Carrot 1
    Kiwi 1
    Watermelon 1
    Egg 2
    Peanut 1

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Count unique data across multiple columns

    Hi

    Do the number of columns change or is it always 3.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2010, 2016
    Posts
    1,173

    Re: Count unique data across multiple columns

    It's between 3 columns and 6 columns. 6 columns is the max. I think if I say 6, 3 will also work. Thanks

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Count unique data across multiple columns

    Hi,

    One way

    Name the upper left cell of your table of lists (e.g. A1 in this example) 'List_Table" and make sure the 5 columns to the right of your lists are empty.

    Please Login or Register  to view this content.

+ 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] Count Unique Values Using Two Columns of Data
    By MidwestBen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-09-2013, 01:09 AM
  2. Count unique values across 2 columns with multiple criteria
    By Skywalker01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-29-2012, 08:04 AM
  3. Count of unique values based on two columns of data
    By JodyMathis1973 in forum Excel General
    Replies: 8
    Last Post: 04-18-2012, 10:11 AM
  4. Replies: 11
    Last Post: 06-09-2011, 03:17 PM
  5. Sort and Count Unique Data in 4 Columns
    By miakayuuki in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-08-2008, 11:22 AM

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