+ Reply to Thread
Results 1 to 4 of 4

Count distinct from multiple columns using a single criterion

  1. #1
    Registered User
    Join Date
    03-22-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2

    Count distinct from multiple columns using a single criterion

    I'm trying to count how many distinct items appear across multiple columns with a single criteria from another column. My ability to use the right words might be keeping me from finding a solution on the web.

    Please Login or Register  to view this content.
    How do I count the distinct entries across multiple columns (skipping over columns with unrelated information)?
    Last edited by JBeaucaire; 04-14-2020 at 02:49 PM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,576

    Re: Count distinct from multiple columns using a single criterion

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

  3. #3
    Registered User
    Join Date
    03-22-2018
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2

    Re: Count distinct from multiple columns using a single criterion

    Here's a spreadsheet. Hopefully, it will help with finding an answer.
    Attached Files Attached Files

  4. #4
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,714

    Re: Count distinct from multiple columns using a single criterion

    Hi,

    What tells us which columns contain the relevant information?

    Based on your file, can we safely assume it's always ever other column? Or, if not, do the relevant columns always contain some common string within the header, e.g. "Restaurant"?

    Also, do you have an Office 365 subscription with your Excel 2016?

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

+ 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. SUMIFs: Multiple ranges, single criterion, OR logic
    By A.Khan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-20-2017, 06:59 AM
  2. COUNTIFs: Multiple ranges, single criterion with OR logic
    By A.Khan in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-20-2017, 06:05 AM
  3. Replies: 3
    Last Post: 11-22-2016, 06:11 AM
  4. AVERAGEIF - single criterion in multiple columns?
    By oyvindh in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-16-2016, 11:10 AM
  5. [SOLVED] Looking up multiple values based on a single criterion
    By wmjenner in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-31-2013, 09:38 PM
  6. [SOLVED] Row count using more than a single criterion?
    By TBrun in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-22-2013, 09:08 AM
  7. [SOLVED] Find Multiple instances of Single Criterion in Row & Return To a Single Col
    By Sam via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 05-09-2006, 10:10 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