8th February 2009, 01:53 PM
|
|
Member
|
|
Join Date: Apr 2006
Posts: 368
|
|
Quote:
|
Originally Posted by thorns
Hmm, it seems that because column b is a formula that adds up the total ratings for each horse, the column itself cant be sorted. So is there a way to take the data from column b, copy it into another column without the formulas attached, so there is nothing stopping it from being sorted?
|
To copy the number into another cell eg. in cell C1 you put =B1 and drag it down the column, this will copy the number only. |