Hi Sir,
Am working on Rating Report for the Employees.
Following is the Table Details:-
Emp ID# /Emp Name /Dept /Supervisor /DOjoining /Exp /Ratings
1 A FINANCE P X 2 2.25
2 B HR Q X 4 3.50
3 C Engineer R X 6 4.75
4 D Engineer S X 8 4.00
5 E FINANCE X X 10 3.00
in the next sheet i need Autoupdate formula which shows for ever one Dept how many employees comes under 0 rating or 1 rating or 2 Rating Respectevly Individually
For example :
Under Dept Finance they are 1 person comes under 2.25 Rating
2 person comes under 3.00 Rating LIKE that
But i need the same in autoupdate Formula...
Kindly Help me on this..............
Harsha.
Am working on Rating Report for the Employees.
Following is the Table Details:-
Emp ID# /Emp Name /Dept /Supervisor /DOjoining /Exp /Ratings
1 A FINANCE P X 2 2.25
2 B HR Q X 4 3.50
3 C Engineer R X 6 4.75
4 D Engineer S X 8 4.00
5 E FINANCE X X 10 3.00
in the next sheet i need Autoupdate formula which shows for ever one Dept how many employees comes under 0 rating or 1 rating or 2 Rating Respectevly Individually
For example :
Under Dept Finance they are 1 person comes under 2.25 Rating
2 person comes under 3.00 Rating LIKE that
But i need the same in autoupdate Formula...
Kindly Help me on this..............
Harsha.