Forum Discussion
PAQ?
Can you click on one cell in a row and then another cell in a column to result in excel plotting the spot they would meet (like an Performance Analysis Quadrant like here https://image.slidesharecdn....
smcgregor Perhaps the attached file works for you. It uses INDEX and MATCH to find the correct quadrant (A, B, C or D) based on scores for Knowledge (Kn) and Attitude (Att). Note that I've used a few named ranges in the formula in J12.