I'm using Excel 2003. I need to calculate the ranking for a group of
employees based on two different categories: sales $ amount and percentage
grade. These two categories are monthly. The two categories have a 50%
weighted average. I need to obtain the overall ranking per employee based on
these two categories for the four month period. Here is an ilustration of
what the data looks like:

J $ J % F $ F% M $ M% A $ A %
EE1 $9 85% $8 83% $7 83% $7 84%
EE2 $7 82% $8 85% $7 80% $8 84%
EE3 $8 81% $8 81% $7 81% $7 80%

Thanks in advance for helping me!
--
Thank you