Excel 2003 ranking with VLOOKUP

5 pts.
Tags:
Excel 2003
Excel 2003 functions
Excel 2003 VLOOKUP function
Microsoft Excel
Microsoft Excel 2003
VLOOKUP
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%

Answer Wiki

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

Maybe something in this <a href=”http://www.cpearson.com/excel/topic.aspx”>excellent Excel resource site</a> 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following