| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting help needed!
I have a column of data in random order and when I Sort the data by ascending order (I have hundreds of pages of these), the result is as below: 62062 62063 62093 89120 20294 SAT 20294 WH 20309 WH 20310 BLK 20310 WH 23109 COLBALT 25013 OS 50362 BS 50362 SB 50367 BS 50368 BS 50370 BS 50370 SB 50398 BS 52030 BS 52032 BS 52106 BS FR 52133 BS 52203 BS 63204 MC/FR 87000 BLK 901 RT BS 930V/C B I need for the data to be in numerical order (ascending) so that (for example) the 901 RT BS is at the top of the list b/c 901 is a smaller value then 930 and the 89120 would be the last b/c 89120 is the largest value number, etc... and I need that to occur even if ther is text at the end of the number. How do you tell Excel to do this? Thanks, Brett -- BrettOlbrys ------------------------------------------------------------------------ BrettOlbrys's Profile: http://www.excelforum.com/member.php...fo&userid=1786 View this thread: http://www.excelforum.com/showthread...hreadid=496583 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| sorting non contiguous ranges | Excel Discussion (Misc queries) | |||
| sorting number in ascending order | Excel Discussion (Misc queries) | |||
| SORTING question | New Users to Excel | |||
| Adding a KeyID column for sorting | New Users to Excel | |||
Threaded Mode
