Hi All,
Need help in creating a formula which helps me in calculating Percentrank (Quintile) based on the Function the employees working with.
Attached document, I have calculated Percentrank (Quintile) based on overall employees scores (Highlighted in Yellow), however, I need a formula where Percentrank (Quintile) is calculated based on Function (Highlighted in Blue & Orange) employees working with and that too formula needs to be created in such a way that Percentrank (Quintile) is calculated within the same function and once function changes, Percentrank (Quintile) should change and calculate accordingly to changed function.
I would be pleased, if any one could assist and help me in creating this formula.
Any doubts, please do revert on this thread would be much appreciated.Working file.xlsb
Thank you, awaiting for your kind response and assistance on this regards.
Regards,
Yadavagiri
Bookmarks