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

J

JulieR

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

Carole O

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
 
S

swatsp0p

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
 
Top