I have a substantial database with multiple entries for employee evaluations – each entry showing YES/NO/NA responses for up to 40 individual questions.
Currently, I have a summary spreadsheet with various formulas (sumproduct, etc) that presents results based on selected employee name and...