5 pts.
 Excel 2003 ranking with 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%

Software/Hardware used:
ASKED: December 5, 2008  7:41 AM
UPDATED: December 5, 2008  9:17 PM

Answer Wiki:
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!
Last Wiki Answer Submitted:  December 5, 2008  9:17 pm  by  Labnuke99   32,645 pts.
All Answer Wiki Contributors:  Labnuke99   32,645 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _