|
Post by PureOldGold on Aug 13, 2007 7:17:29 GMT -1
Is there any one on here who uses excel regularly and knows all its functions. I have a list of people with scores and i am trying to put them in order of highest scorer, how would i do this? Hit me back this is your favourite fan this is stan Addicted2venos 9 Alex 5 Arnie 5 BadWolf 9 Billy 6 BW 4 CarrowGirl 8 CmonYouSpurs 4 Coxy 11 Cujo 8 dcfccappsy 8 Foesttillidie 0 Frog Maniac 2 6 Giar 8 Gres 10 GW 6 Hannah 8 JJ 8 LFCLuke 4 LondonRam 0 Oveckin 8 8 Pastie 9 Peschi 7 PureOldGold 3 SheepShag 7 Sleepylaidlaw 4 Smakmagic 0 Spozz 9 Tenacious Lee 9 The Lucky C 7 Travis 4
|
|
|
Post by ITFC Dudette6 on Aug 13, 2007 8:31:14 GMT -1
You have to highlight the two columns, and then press the A-Z with the downward arrow thing. I think there are options for it, so then you have to sort it as the number. That's not a very clear explanation really
|
|
|
Post by PureOldGold on Aug 13, 2007 9:22:54 GMT -1
i'll try when i get back home, thanks han.
|
|
|
Post by Argyle_Smurf on Aug 13, 2007 9:25:02 GMT -1
To put them in order of highest scorer, put the scores in a seperate column, highlight all the boxes in the column, then press what Han so eloquently called the 'A-Z with the downward arrow thing'
|
|
|
Post by ITFC Dudette6 on Aug 13, 2007 9:25:56 GMT -1
To put them in order of highest scorer, put the scores in a seperate column, highlight all the boxes in the column, then press what Han so eloquently called the 'A-Z with the downward arrow thing' My description was awesome and you know it
|
|
|
Post by PureOldGold on Aug 13, 2007 9:27:31 GMT -1
To put them in order of highest scorer, put the scores in a seperate column, highlight all the boxes in the column, then press what Han so eloquently called the 'A-Z with the downward arrow thing' i did try that but in put them in alphabetic order
|
|
|
Post by PureOldGold on Aug 13, 2007 9:28:27 GMT -1
To put them in order of highest scorer, put the scores in a seperate column, highlight all the boxes in the column, then press what Han so eloquently called the 'A-Z with the downward arrow thing' My description was awesome and you know it it did the job
|
|
|
Post by ITFC Dudette6 on Aug 13, 2007 9:29:11 GMT -1
To put them in order of highest scorer, put the scores in a seperate column, highlight all the boxes in the column, then press what Han so eloquently called the 'A-Z with the downward arrow thing' i did try that but in put them in alphabetic order Have you got the names and the numbers in separate boxes?
|
|
|
Post by PureOldGold on Aug 13, 2007 9:31:53 GMT -1
i did try that but in put them in alphabetic order Have you got the names and the numbers in separate boxes? yep i'll try it again later, its probably me being stupid again.
|
|
|
Post by ITFC Dudette6 on Aug 13, 2007 9:38:19 GMT -1
Have you got the names and the numbers in separate boxes? yep i'll try it again later, its probably me being stupid again. Highlight the numbers column first (ie so the first white box is on a number). I've just tried it and it seems to have worked for me
|
|
|
Post by PureOldGold on Aug 13, 2007 9:40:45 GMT -1
yep i'll try it again later, its probably me being stupid again. Highlight the numbers column first (ie so the first white box is on a number). I've just tried it and it seems to have worked for me Thanks Han, will do when i get back home
|
|
|
Post by ITFC Dudette6 on Aug 13, 2007 9:42:46 GMT -1
Highlight the numbers column first (ie so the first white box is on a number). I've just tried it and it seems to have worked for me Thanks Han, will do when i get back home OK, hope it helped
|
|
|
Post by PureOldGold on Aug 13, 2007 13:23:08 GMT -1
done. thanks han and neko.
|
|
|
Post by Argyle_Smurf on Aug 13, 2007 19:39:49 GMT -1
done. thanks han and neko. Excuse me? Have I changed my name?
|
|
|
Post by PureOldGold on Aug 13, 2007 19:41:10 GMT -1
done. thanks han and neko. Excuse me? Have I changed my name? sorry argylesmurf
|
|
|
Post by Neko Bazu on Aug 14, 2007 7:07:59 GMT -1
I was wondering what I'd done to deserve that gratitude! ;D
|
|