I used the Index and Match to determine the course in question, then tossed it into a traditional Pivot Table. It's an approach I learned from watching ExcelIsFun!
The potential problem that I see here is how the "name" column might not be unique in the future. Unique numbers that can't change or be reused by another like student IDs are better candidates for that column. But I sure you guys have already thought of that.
Thanks for another great video, Power pivot table looks like a new feature in 2010, I really need to install the latest office.
Mr Excel...dam you guys are brilliant
Lightin77 5 months ago
@Lightin77 , not so much brilliant, just having fun with Excel!
ExcelIsFun 5 months ago
What did you click @1:38 to open the PowerPivot?
foralloccasions 5 months ago
@foralloccasions , you have to download and install the PowerPivot add-in. It doesn't come with Excel 2010.
ExcelIsFun 5 months ago
Very cool solution.
I used the Index and Match to determine the course in question, then tossed it into a traditional Pivot Table. It's an approach I learned from watching ExcelIsFun!
dmr450 5 months ago
@dmr450 , cool!
ExcelIsFun 5 months ago
Great Video! but,
Why hasn't you attached the workbook to this trick?
loyaus 5 months ago
@loyaus , I did not have the PowerPivot Solution from Mr Excel. But on Monday I can upload the raw data set and my solution.
ExcelIsFun 5 months ago
The potential problem that I see here is how the "name" column might not be unique in the future. Unique numbers that can't change or be reused by another like student IDs are better candidates for that column. But I sure you guys have already thought of that.
Thanks for another great video, Power pivot table looks like a new feature in 2010, I really need to install the latest office.
JessMenu 5 months ago
@JessMenu , Yes, if the student id was given, that would be much better!
ExcelIsFun 5 months ago