Group Cells and Rank based on values

**sharahoff** · 12-17-2012, 11:08 AM

I have a worksheet with 2 rows of data. The first row contains heading information and the second row contains values. I need to rank the values and their sums while keeping the heading information attached.

Attached is an example worksheet.

Thanks for your help!

**FDibbins** · 12-17-2012, 11:50 AM

in J5, use this...
=LARGE(A3:A15,1)
in K5, use this copied across...
=INDEX($A$2:$F$15,MATCH($J3,$A$2:$A$15,0),MATCH(K$2,$A$2:$F$2,0))

for the other rows, copythe above down, but change the =LARGE(A3:A15,1) to =LARGE(A3:A15,2) =LARGE(A3:A15,3) etc

**sharahoff** · 12-17-2012, 12:50 PM

Thank you for your quick response and attention. However, I'm having some trouble with this. I used the formulas your provided but the index reference came up with a value error. I tired tweaking it a bit to make sure I was entering into the right cells but had no luck.

I attached a new worksheet for clarification in case the previous version was not.

**FDibbins** · 12-17-2012, 01:19 PM

the reason for the errors was that the 2nd table had moved to the right. also, i didnt realise you wanted the table sorted by the "sum" column. see if the attraqched is what you want?