Another easy excell question

[dugweb]

on a spreadsheet i have about 8 columbs and 20 rows... i want to rank the list by the values in the 8th columb. anyway to do this?

 

[KLin]

highlight the whole dataset
click on data
click sort
choose the 8th column under Sort By,
then choose ascending or descending order.

 

[NeoV]

no...use the rank command instead of having to resort your data

=rank(cell,range)

 

[dugweb]

Originally posted by: NeoV
no...use the rank command instead of having to resort your data

=rank(cell,range)

could you elaborate on that a little? i dont understand

thanks for the help btw

 

[skiersteve]

Originally posted by: dugweb

Originally posted by: NeoV
no...use the rank command instead of having to resort your data

=rank(cell,range)

could you elaborate on that a little? i dont understand

thanks for the help btw

Sorry if I am oversimplifing here...

What hes saying is that the "cell" is the value you are ranking against the "range". So if you want to rank all of the 8th ("H") column it would be:

=RANK(H1,$H$1:$H$20)
(Cell,Range)

Put that formula into an open cell ("I1" perhaps), drag it down to the last cell location and it should automatically update as needed.

If your data column gets larger, you would just change the "Range" to the last row with data you want to rank against.

 

[dugweb]

perfect, thanks yall