PowerPivot or Helper Column & PivotTable & Custom Number Format
1. See Mr Excel and excelisfun try to take a database with repeat names of students with failing Grades and create a unique list of student names that shows an “X” for each class that falls into a Class Category.
2. Mr Excel uses PowerPivot and excelisfun uses two Helper Column Formulas and a PivotTable.
3. Also learn about Custom Number formatting
4. Learn about default setting for empty cells in a Pivot Table using PivotTable Options