Ranking

  • Thread starter Thread starter pkbravo
  • Start date Start date
P

pkbravo

i have percentages on six sheets of a work book.
on the 7th sheet. i want to rank these percentages from lowest
to highest. i've tried using the SMALL function but cannot get it t
work.
here's the formula. any help would be greatly appreciated :confused:


=SMALL((cincinnati!L58,atlanta!L59,perimeter!L58,'ston
point'!L59,newport!L59),1
 
I'm not an expert but i've tried to funcion Rank(on the column %) and it
works fine with me
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting text 2
Ranking Without Skipping Ranks When a Tie Occurs 4
Pivot Tables - Ranking Values 1
Highlighting the differences between lists. 4
Ranking Query For Multiple Groups using percentages 1
How to Rank Name? 4
how can i trace position in marks sheet 3
Want cell ref. to change after sort in other sheet 1

Back
Top