Urgent Ranking Help Requested

[LilDan]

Pleas help. I have been attempting to get this Rank thing to work for 4 hours. I'm quite frustrated. I need to Rank the below individuals based on QA1,QA2,Sales, and Absences from 1-14 with 1 being the highest out of the four categories.

	QA1	QA2	Sales	Absences
Nicole	0%		404
Angel	79%	0%	17026
Dan	100%	100%	505
Jes
Ty	100%	100%	19884
Dustin
Will	95%	95%	12540	-1
Jo	100%	100%	150
Serg	100%	0%	18978	-4.5
Ashleigh	100%	90%	16850	-3
Rudie	90%	87%	5326
George	80%	100%	11072

<tbody>
</tbody>

I appreciate any assistance in advance!

 

[CyrusTheVirus]

Welcome to the forums. Can you please show your expected results?

 

[Peter_SSs]

Welcome to the MrExcel board!

Since you are new here, you may not yet have read the Forum Use Guidelines, particularly 5g and 5h in section A.

 

[DanteAmor]

I guess you should have a weighting, to find out what is more important, if the Q1 or Q2 or the sales or absences.
If not, you could add a column A, and put a consecutive number, then order column Q1 from highest to lowest, then Q2 from highest to lowest, then sales from highest to lowest and finally absences from most to less.
In the Rank column you put the consecutive one from 1 to 12.
Then you can return to the original order by ordering Colunmna A.


<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ffff00; ">ID</td><td style="background-color:#ffff00; ">NAME</td><td style="background-color:#ffff00; ">QA1</td><td style="background-color:#ffff00; ">QA2</td><td style="background-color:#ffff00; ">Sales</td><td style="background-color:#ffff00; ">Absences</td><td style="background-color:#ffff00; ">Rank</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">5</td><td >Ty</td><td style="text-align:right; ">100%</td><td style="text-align:right; ">100%</td><td style="text-align:right; ">19884</td><td > </td><td style="text-align:right; ">1</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">3</td><td >Dan</td><td style="text-align:right; ">100%</td><td style="text-align:right; ">100%</td><td style="text-align:right; ">505</td><td > </td><td style="text-align:right; ">2</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">8</td><td >Jo</td><td style="text-align:right; ">100%</td><td style="text-align:right; ">100%</td><td style="text-align:right; ">150</td><td > </td><td style="text-align:right; ">3</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">10</td><td >Ashleigh</td><td style="text-align:right; ">100%</td><td style="text-align:right; ">90%</td><td style="text-align:right; ">16850</td><td style="text-align:right; ">-3</td><td style="text-align:right; ">4</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">9</td><td >Serg</td><td style="text-align:right; ">100%</td><td style="text-align:right; ">0%</td><td style="text-align:right; ">18978</td><td style="text-align:right; ">-4.5</td><td style="text-align:right; ">5</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">7</td><td >Will</td><td style="text-align:right; ">95%</td><td style="text-align:right; ">95%</td><td style="text-align:right; ">12540</td><td style="text-align:right; ">-1</td><td style="text-align:right; ">6</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="text-align:right; ">11</td><td >Rudie</td><td style="text-align:right; ">90%</td><td style="text-align:right; ">87%</td><td style="text-align:right; ">5326</td><td > </td><td style="text-align:right; ">7</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="text-align:right; ">12</td><td >George</td><td style="text-align:right; ">80%</td><td style="text-align:right; ">100%</td><td style="text-align:right; ">11072</td><td > </td><td style="text-align:right; ">8</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="text-align:right; ">2</td><td >Angel</td><td style="text-align:right; ">79%</td><td style="text-align:right; ">0%</td><td style="text-align:right; ">17026</td><td > </td><td style="text-align:right; ">9</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="text-align:right; ">1</td><td >Nicole</td><td style="text-align:right; ">0%</td><td style="text-align:right; ">0</td><td style="text-align:right; ">404</td><td > </td><td style="text-align:right; ">10</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="text-align:right; ">4</td><td >Jes</td><td > </td><td > </td><td > </td><td > </td><td style="text-align:right; ">11</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="text-align:right; ">6</td><td >Dustin</td><td > </td><td > </td><td > </td><td > </td><td style="text-align:right; ">12</td></tr></table>