I'm trying to work out an excel formula that will show me a number based upon information from another worksheet in the same book.
Basically, I have 14 people who through other formulas each have an average rating, but for my front cover of the work book, I want to show the following information;
Percentage of TL's ranked 2 or less
Percentage of TL's ranked 3
Percentage of TL's ranked 4 or more
I can't seem to figure out what formula I need though to show me this information.
however once all my source information is generated, it won't show me a number that gives me an indication of how many out of 14 are ranked <2, 3, 4> as a percentage.
Any help would be greatly appreciated.