I have a table which ranks employee training for: Excel, Word, PowerPoint, and Outlook.
Column A - has the employee completed training for all four Office programs? Y/N
Col B - employee name
Col C-F - ranks 1 through 4 each Office program according to employee proficiency (E, W, P, O)