rank calculations

hi

need a help with an excel . i need to rank few users in my team based upon few parameters. i have tried using rank function and weighted average method but the result is skewed. all the parameters are of equal importance and ranking should be based on considering each of these parameters. help would be appreciated. sample data as follows

trick here is for the No quote and feedback parameters , one with least value is the best and for remaining parameters , one with max is the best

Week 19
Sl No Rep Name No Quote % $/Quote Quotes Daily Avg Parts/Quote Gruping quotes % of Manual $ Feedbacks
1 axbaig 27.64% $1,136.32 147 5.4 18.50% 23.59% 0.25
2 bxkrishn 33.89% $877.71 165 4.6 12.36% 21.20% 0.08
3 cvbhat 46.48% $1,293.36 162 5.8 22.44% 34.77% 0.25
4 exchuncha 38.98% $877.55 174 4.8 10.37% 16.73% 0.25
5 kkkumar 39.44% $1,082.40 172 5.4 23.58% 15.77% 0.13
6 lsjangam 39.51% $844.82 177 4.5 13.53% 16.91% 0.10
7 nxkumar 24.59% $1,120.90 171 6.5 11.33% 15.73% 0.18
8 sgvenkatai 28.78% $1,914.27 198 7.9 31.12% 38.28% 0.13
9 kygopal 28.93% $1,209.33 150 6.1 22.33% 13.90% 0.10
10 vmkumar 50.97% $977.51 199 4.8 15.81% 21.88% 0.40
11 hbyogshett 26.65% $1,062.24 156 5.7 14.21% 11.16% 0.23
12 axdas 52.48% $978.71 166 4.6 18.12% 24.23% 0.13
13 sxmadava 36.91% $1,215.20 164 6.5 17.20% 14.64% 0.15
14 nskumar 37.39% $969.27 156 5.0 17.84% 19.49% 0.10
16 mmdevan 34.79% $1,042.73 182 5.2 18.43% 17.87% 0.13
17 ahchandra 39.32% $1,073.50 139 4.9 20.95% 26.24% 0.20
18 kxmuniram 35.63% $931.55 149 5.1 15.70% 15.64% 0.25
19 vgprakash 33.63% $851.02 132 4.6 10.83% 8.13% 0.03
21 vkshetty 28.06% $1,406.62 144 6.5 27.22% 20.90% 0.30
22 sxlakshman 29.60% $886.30 140 4.2 14.00% 25.22% 0.10
23 prsreddy 41.38% $1,025.34 178 5.7 7.18% 16.01% 0.20
24 vkmahesh 40.64% $934.40 142 5.1 13.22% 19.14% 0.18
25 dsgowda 38.71% $1,046.99 117 4.9 22.01% 21.15% 0.18
26 smprasad 29.08% $774.47 143 3.6 11.78% 20.37% 0.05
27 vbashwathn 50.01% $1,038.24 103 4.9 24.31% 23.83% 0.05
28 bdkotambri 33.68% $1,098.62 136 5.5 11.62% 14.00% 0.28
29 ngramanji 27.94% $1,045.91 127 5.1 11.16% 21.53% 0.30
30 NPN 29.46% $1,233.59 126 6.0 21.94% 22.92% 0.18
31 pcraj 42.50% $980.76 129 5.3 14.13% 14.05% 0.15
32 aaeshwar 40.72% $972.19 144 5.2 14.56% 11.07% 0.08
33 jxdharmar 45.49% $1,057.36 146 4.6 19.34% 27.57% 0.25

hi ,

i tried doing the same . it gave me N/A as a result. also i din not understand what you want me to do with the rank function. should i first find the ranks of the individual columns and then run the formula. can you please elaborate.

regards
vishal