|
|
Post by Fizzy Bread on May 15, 2007 16:26:22 GMT -1
Yours truly here  How does one get values on a spreadsheet in descending order? Yes I feel like a div not being able to figure it out; so do your bit today and help someone in need! |
|
|
|
Post by Teesside White on May 15, 2007 16:27:33 GMT -1
highlight column
click the Z to A button
|
|
|
|
Post by Fizzy Bread on May 15, 2007 16:30:10 GMT -1
Doesn't work as I've got names next to the numbers, makes it go alphabetical.  |
|
|
|
Post by Teesside White on May 15, 2007 16:30:50 GMT -1
can u put them in seperate columns?
|
|
|
|
Post by CHOPPER READ on May 15, 2007 16:31:06 GMT -1
What number am i? Doesn't work as I've got names next to the numbers, makes it go alphabetical. |
|
|
|
Post by Fizzy Bread on May 15, 2007 16:33:41 GMT -1
What number am i? Doesn't work as I've got names next to the numbers, makes it go alphabetical. You're not on it  |
|
|
|
Post by CHOPPER READ on May 15, 2007 16:34:55 GMT -1
 You're not on it
|
|
|
|
Post by ITFC Dudette6 on May 15, 2007 16:36:28 GMT -1
Doesn't work as I've got names next to the numbers, makes it go alphabetical. If you have the Excel I have, I think you highlight all the data, go to 'Data', then 'Sort' (the Z-A thingy) and then choose the column and click 'descending' on the right... |
|
|
|
Post by Fizzy Bread on May 15, 2007 16:36:59 GMT -1
You're not on it Well if you'd done the prem predictions, you'd be on it! |
|
|
|
Post by CHOPPER READ on May 15, 2007 16:38:54 GMT -1
I correctly predicted that Warnock was a grade A tossbank. Well if you'd done the prem predictions, you'd be on it! |
|
|
|
Post by Fizzy Bread on May 15, 2007 16:38:55 GMT -1
Doesn't work as I've got names next to the numbers, makes it go alphabetical. If you have the Excel I have, I think you highlight all the data, go to 'Data', then 'Sort' (the Z-A thingy) and then choose the column and click 'descending' on the right... Han, my darling, you are fantastic! Thank you |
|
|
|
Post by Fizzy Bread on May 15, 2007 16:39:31 GMT -1
I correctly predicted that Warnock was a grade A tossbank. Well if you'd done the prem predictions, you'd be on it! Who didn't? |
|
|
|
Post by ITFC Dudette6 on May 15, 2007 16:40:11 GMT -1
If you have the Excel I have, I think you highlight all the data, go to 'Data', then 'Sort' (the Z-A thingy) and then choose the column and click 'descending' on the right... Han, my darling, you are fantastic! Thank you Glad to be of assistance!  Now back to revising Physics... |
|
|
|
Post by CHOPPER READ on May 15, 2007 16:40:15 GMT -1
Warnock. I correctly predicted that Warnock was a grade A tossbank. Who didn't? |
|
|
|
Post by officergroyman on May 15, 2007 18:39:31 GMT -1
Well if you'd done the prem predictions, you'd be on it! I know I'm at the top because AMAZING comes before AWESOME alphabetically, plus I'm already No. 1 everyone agrees with that.  |
|
