# Unique values with Multiple Criteria for Pivoting

1. ## 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.

2. ## Re: Unique values with Multiple Criteria for Pivoting

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. ## Re: Unique values with Multiple Criteria for Pivoting

How to delete this post?

4. ## 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.

There are currently 1 users browsing this thread. (0 members and 1 guests)