|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
March 6th, 2008, 05:16 PM
|
|||
|
|||
|
Excel list
Hi, I don't know where to post this but this seems to be the best place.
I made a VERY basic excel list actually, can't even call it a database. I got 1 column with words which I want to be able to sort. The thing is I don't want to sort them alphabetically but according to their value. I got these words: Easy, Normal, Hard, Brutal I want to be able to arrange them like that, not alphabetically. Does anyone know how? Thanks
|
|
#2
March 7th, 2008, 10:39 AM
|
|||
|
|||
|
It's called a manual sort.
You need criteria to sort. Given those words there is no sort criteria. Attach a value to them and you can sort on that value.
|
|
#3
March 7th, 2008, 11:13 AM
|
||||
|
||||
|
You can add a column then use a formula to assign a rank in a new column and sort on that column.
Say you insert a new column A and your col B has "Easy, Normal, Hard, Brutal" This: Code:
=IF(B1="Easy",1,IF(B1="Normal",2,IF(B1="Hard",3,IF(B1="Brutal",4,0)))) =IF(B1="Easy",1,IF(B1="Normal",2,IF(B1="Hard",3,IF(B1="Brutal",4,0)))) Will assign 1 to easy, 2 to normal, 3 to hard, 4 to brutal (0 for anything else). Copy it down the whole column then sort.
__________________
medialint.com "Energy has the opportunity to change the climate if it's done right." - Sen. John Ensign, R-Nev. (quoted out of context)
|
|
| Viewing: Dev Shed Forums > Operating Systems > Windows Help > Excel list |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
