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.
Bookmarks