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. [...]