Excel 2003 ranking with VLOOKUP

5 pts.
Tags:
Excel 2003 VLOOKUP function
Microsoft Excel
Microsoft Excel 2003
microsoft excel functions
I know there is a way to rank a list without using the "sort" feature in excel but rather formulas. I need to sort the list of 25 items below by the first column with the highest value first. What formulas do I use? Thanks for the help.
Weight Management 65% 74% 67% 84% 75%
Healthy Heart 46% 24% 88% 56% 83%
Healthy Immune Sys 54% 27% 33% 32% 35%
Healthy Mind 27% 33% 32% 35% 75%
Healthy Vision 65% 74% 36% 44% 36%
Healthy Aging 65% 74% 67% 84% 75%
Pain Free 48% 66% 36% 39% 31%
Healthy Teeth and Gums 33% 32% 35% 77% 79%
Relaxation & Replenishment 70% 81% 33% 32% 35%
Natural Energy 32% 35% 50% 32% 75%
Bone & Joint Health 35% 50% 32% 84% 75%
Healthy Bones 51% 38% 54% 27% 75%
Men’s Everyday Health 65% 74% 67% 84% 75%
Women’s Wellness 49% 51% 38% 54% 27%
Healthy Skin 49% 60% 40% 33% 75%
Healthy Kids 65% 74% 67% 84% 75%
Diabetes Prvntion & Maintnc 75% 82% 81% 82% 79%
Digestive Health 39% 37% 36% 44% 78%
Allergy Relief & Prevention 70% 39% 37% 36% 44%
Healthy Teens 70% 58% 41% 39% 37%
Intimacy 58% 41% 39% 37% 78%
Cold and Flu Prevention 70% 77% 75% 84% 78%
Home Healthcare 55% 40% 58% 84% 78%
Healthy Pregnancy 78% 50% 32% 36% 78%
Healthy Babies 62% 49% 51% 38% 32%

Thanks. We'll let you know when a new response is added.

Maybe something in this excellent Excel resource site will help you.
******
SbElectric

Yes, you can rank a column. Insert a new col A before the existing data. So Col C will be the one to be ranked.
On A2 use =RANK(C2,C\$2:C\$26) & then populate similarly to A26.
Use =RANK(C2,C\$2:C\$26,1) if you want rank in descending.
If you want to be fancy, you may use conditional formatting to shade the top 5 in green color and the bottom 5 in red!

Discuss This Question:

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.