You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How to determine top category in employee scorecard
- Thread starter BigD
- Start date
NARAYANK991
Excel Ninja
Hi ,
It would be nice if you could give an example for one employee.
For both employees , only their scores for January have been given ; for employee 1 , the category with the lowest score is Learning Abilities , while for employee 2 , the category with the lowest score is Organization Commitment.
It is not necessary that for any employee , the category with the lowest score will remain the same across the months ; how exactly do you want the output ? Can you take several months of data and indicate the output that you want ?
Narayan
It would be nice if you could give an example for one employee.
For both employees , only their scores for January have been given ; for employee 1 , the category with the lowest score is Learning Abilities , while for employee 2 , the category with the lowest score is Organization Commitment.
It is not necessary that for any employee , the category with the lowest score will remain the same across the months ; how exactly do you want the output ? Can you take several months of data and indicate the output that you want ?
Narayan
Thank you for the reply. I apologize that my example was bad. This may not be possible without a tremendous amont of work.
I was hoping I could get a spreadsheet to calculate all employees average score for all cateogies in Janurary and output the worst category
See if this file helps.
I was hoping I could get a spreadsheet to calculate all employees average score for all cateogies in Janurary and output the worst category
See if this file helps.
Attachments
NARAYANK991
Excel Ninja
Hi ,
OK , now I understand. So you want to know the lowest score category across the 12 months.
How many employees will you have ? Having each employees score across tabs makes it more difficult to compare.
Do you have any earlier spreadsheet with enough data ? Can you upload it ?
Narayan
OK , now I understand. So you want to know the lowest score category across the 12 months.
How many employees will you have ? Having each employees score across tabs makes it more difficult to compare.
Do you have any earlier spreadsheet with enough data ? Can you upload it ?
Narayan
NARAYANK991
Excel Ninja
Is it necessary to have them across tabs? If it is not necessary it would be substantially simpler if you were to have all employees on one tab. Just add an 'Employee Name' or 'Employee ID' column to identify with each row.
If they each have to be on their own tab....it is probably easiest to collect all the data, then compile it with VBA to get a summary. If your not into VBA, you may be able to use multiple consolidation ranges as posted here http://www.contextures.com/xlPivot08.html. I have used them before and while they do work, they are a bit finicky in my opinion.
If they each have to be on their own tab....it is probably easiest to collect all the data, then compile it with VBA to get a summary. If your not into VBA, you may be able to use multiple consolidation ranges as posted here http://www.contextures.com/xlPivot08.html. I have used them before and while they do work, they are a bit finicky in my opinion.