Quote Originally Posted by Gregb11 View Post
You're not giving enough detail. First, is the Combined Average better if higher? I assume the higher the attendance rate the better. Is it the same for the Cleanliness?
Why don't you rank all 3 and add them together (using a factor) (instead of using SUMPRODUCT). You don't say how you want to weight the rankings of each category. So lets say EXCEL was out of the picture and you had to do it by hand, what would you do? (Explain the process in words).
Combine Avg would be better if lower, attendance rate AND cleanliness if higher. Ideally I would like for all three to weight equally when ranking, but if not. Then combine average to have the most weight followed by cleanliness and lastly attendance. How would I do that? I apologize I’m not too savy on excel