+ Reply to Thread
Results 1 to 4 of 4

Unique values with Multiple Criteria for Pivoting

  1. #1
    Registered User
    Join Date
    02-26-2019
    Location
    Bulacan
    MS-Off Ver
    2016
    Posts
    2

    Lightbulb Unique values with Multiple Criteria for Pivoting

    Hi Excel Masters,

    I just need your assistance on how to answer the 'CourseAccessed' column from my table, wherein it will put 1 for each Unique 'Username' accessed(TimesAccessed) a Unique course in 'CourseTitle' column whatever Lesson(LessonNumber) it is, as long as he accessed the course.

    Here is the table of my example:
    Unique Values with Multiple Criteria img.PNG

    My idea here is to create a pivot table, and sum the number of users who accessed the courses. So I will be able to see the trending course accessed by the users.
    And yes, the 'CourseAccessed' is a helper column so I can do the counting with the value 1 if TRUE and 0 if False.

    Here's how it should look like:
    Unique Values with Multiple Criteria img1.PNG

    Unfortunately, I only did put values manually in the CourseAccessed, I need formula there so that it will work dynamically with hundreds of rows.
    And after putting the value, i can then do the pivot that will count the number of access per unique Course by unique Username regardless what LessonNumber they took. And it should look like this:

    Unique Values with Multiple Criteria img2.PNG

    I appreciate your help guys. Thanks in advance. I'm getting crazy on how to do this formula right now.
    If you have better ideas, please feel free to share. It would be wonderful to do brainstorming about it.

    More powers to your website.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,403

    Re: Unique values with Multiple Criteria for Pivoting

    crossposted: https://chandoo.org/forum/threads/un...9/#post-247385

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. I have done this for you today. Please read our forum rules and abide by them in the future.)

  3. #3
    Registered User
    Join Date
    02-26-2019
    Location
    Bulacan
    MS-Off Ver
    2016
    Posts
    2

    Re: Unique values with Multiple Criteria for Pivoting

    How to delete this post?

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,875

    Re: Unique values with Multiple Criteria for Pivoting

    There is. I need to delete it, it if you got a solution on Chandra, please share it here.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ 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] SUM Unique Values with Multiple Criteria
    By mvpscm in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 07-16-2018, 08:21 AM
  2. [SOLVED] Countif unique values with multiple criteria
    By Perk1961 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-27-2017, 05:00 PM
  3. sum unique values with multiple criteria
    By tahas in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-17-2017, 02:03 AM
  4. [SOLVED] Sum unique values with multiple criteria
    By Billaus in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 10-11-2014, 10:48 PM
  5. count unique values in multiple worksheets with multiple criteria
    By craig04 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-06-2012, 03:26 PM
  6. Replies: 8
    Last Post: 07-13-2012, 06:00 AM
  7. Macro to remove duplicates values and keep unique values bases on multiple criteria
    By Ricker090 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-16-2011, 04:37 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