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.

[TABLE="width: 241"]
<tbody>[TR]
[TD="width: 62, bgcolor: transparent"][/TD]
[TD="width: 62, bgcolor: transparent"]QA1
[/TD]
[TD="width: 62, bgcolor: transparent"]QA2
[/TD]
[TD="width: 62, bgcolor: transparent"]Sales
[/TD]
[TD="width: 70, bgcolor: transparent"]Absences
[/TD]
[/TR]
[TR]
[TD="width: 62, bgcolor: transparent"]Nicole
[/TD]
[TD="width: 62, align: right"]0%
[/TD]
[TD="width: 62, bgcolor: transparent"][/TD]
[TD="width: 62, align: right"]404
[/TD]
[TD="width: 70, align: right"][/TD]
[/TR]
[TR]
[TD="width: 62, bgcolor: transparent"]Angel
[/TD]
[TD="width: 62, align: right"]79%
[/TD]
[TD="width: 62, align: right"]0%
[/TD]
[TD="width: 62, align: right"]17026
[/TD]
[TD="width: 70, align: right"][/TD]
[/TR]
[TR]
[TD="width: 62, bgcolor: transparent"]Dan
[/TD]
[TD="width: 62, align: right"]100%
[/TD]
[TD="width: 62, align: right"]100%
[/TD]
[TD="width: 62, align: right"]505
[/TD]
[TD="width: 70, align: right"][/TD]
[/TR]
[TR]
[TD="width: 62, bgcolor: transparent"]Jes
[/TD]
[TD="width: 62, bgcolor: transparent"][/TD]
[TD="width: 62, bgcolor: transparent"][/TD]
[TD="width: 62, bgcolor: transparent"][/TD]
[TD="width: 70, align: right"][/TD]
[/TR]
[TR]
[TD="width: 62, bgcolor: transparent"]Ty
[/TD]
[TD="width: 62, align: right"]100%
[/TD]
[TD="width: 62, align: right"]100%
[/TD]
[TD="width: 62, align: right"]19884
[/TD]
[TD="width: 70, align: right"][/TD]
[/TR]
[TR]
[TD="width: 62, bgcolor: transparent"]Dustin
[/TD]
[TD="width: 62, bgcolor: transparent"][/TD]
[TD="width: 62, bgcolor: transparent"][/TD]
[TD="width: 62, bgcolor: transparent"][/TD]
[TD="width: 70, align: right"][/TD]
[/TR]
[TR]
[TD="width: 62, bgcolor: transparent"]Will
[/TD]
[TD="width: 62, align: right"]95%
[/TD]
[TD="width: 62, align: right"]95%
[/TD]
[TD="width: 62, align: right"]12540
[/TD]
[TD="width: 70, align: right"]-1
[/TD]
[/TR]
[TR]
[TD="width: 62, bgcolor: transparent"]Jo
[/TD]
[TD="width: 62, align: right"]100%
[/TD]
[TD="width: 62, align: right"]100%
[/TD]
[TD="width: 62, align: right"]150
[/TD]
[TD="width: 70, align: right"][/TD]
[/TR]
[TR]
[TD="width: 62, bgcolor: transparent"]Serg
[/TD]
[TD="width: 62, align: right"]100%
[/TD]
[TD="width: 62, align: right"]0%
[/TD]
[TD="width: 62, align: right"]18978
[/TD]
[TD="width: 70, align: right"]-4.5
[/TD]
[/TR]
[TR]
[TD="width: 62, bgcolor: transparent"]Ashleigh
[/TD]
[TD="width: 62, align: right"]100%
[/TD]
[TD="width: 62, align: right"]90%
[/TD]
[TD="width: 62, align: right"]16850
[/TD]
[TD="width: 70, align: right"]-3
[/TD]
[/TR]
[TR]
[TD="width: 62, bgcolor: transparent"]Rudie
[/TD]
[TD="width: 62, align: right"]90%
[/TD]
[TD="width: 62, align: right"]87%
[/TD]
[TD="width: 62, align: right"]5326
[/TD]
[TD="width: 70, align: right"][/TD]
[/TR]
[TR]
[TD="width: 62, bgcolor: transparent"]George
[/TD]
[TD="width: 62, align: right"]80%
[/TD]
[TD="width: 62, align: right"]100%
[/TD]
[TD="width: 62, align: right"]11072
[/TD]
[TD="width: 70, align: right"][/TD]
[/TR]
</tbody>[/TABLE]

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>