bankerturnedconsultant
New Member
- Joined
- Apr 6, 2023
- Messages
- 9
- Office Version
- 2021
- Platform
- Windows
Hi there, I need some help! I have two datasets:
First dataset and I need help with calculating the last column i.e. the cohort ranking:
Second dataset:
My question:
In the first table last column (Cohort Ranking), how do I calculate that for Employee A, based on the job title, location and total hours worked, they fall in X quartile?
So for example for Employee A it should say 1st quartile, Employee B should say 4th quartile and so on.
Can you please help me? Thank you!
First dataset and I need help with calculating the last column i.e. the cohort ranking:
Name | Job Title | Location | Total Hours worked | Cohort Ranking |
A | Analyst | London | 10 | |
B | Associate | Milan | 20 | |
C | Analyst | London | 40 |
Second dataset:
Job Title | Location | 1st quartile | 2nd quartile | 3rd quartile | 4th quartile |
Analyst | London | 10 | 20 | 30 | 40 |
Associate | Milan | 5 | 10 | 15 | 20 |
My question:
In the first table last column (Cohort Ranking), how do I calculate that for Employee A, based on the job title, location and total hours worked, they fall in X quartile?
So for example for Employee A it should say 1st quartile, Employee B should say 4th quartile and so on.
Can you please help me? Thank you!