How do i sort a group of cells from highest to lowest

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet and I'm trying to rate my winners based on their
percentages from 1-10.
 
Julie

After you select the entire spreadsheet, go to Data, Sort, and choose the
Percentage column. You also want to select Descending.

Hope this helps,

Carole O
 
First, you could do a simple sort. Highlight the data range in question,
click Data>Sort and follow instructions.

--OR--

in a helper column, (e.g. col. B) enter this formula in B1, which assumes
your data is in cells A1:A25 and copy down to B25:

=RANK(A1,$A$1:$A$25,1)

This will give the rank of every value in the list, with the highest value
returning '1', next highest returns '2' and so on...

You can then sort by this range, if desired.

HTH
__________________
Bruce
 
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

Create rating with coloring cell 10
Showing the top result from a range of cells 6
How to create percentages for the combined rows? 1
Auto Sorting Data in Table 1
Graph Highest to Lowest. 2
Subtracting Values from a Ranked List 4
Highest High and Lowest Low 6
DISPLAY PERSON'S NAME WITH HIGHEST PERCENTAGE OF SALES 4

Back
Top