sorting excel data
Thanks, BJ....I'm glad you liked it.
***********
Best Regards,
Ron
XL2002, WinXP
"bj" wrote:
I like your method It would be easily expandable to greater than -100
additionally after the sort, it could go backwards to initial format by
find -0 repace by -
"Ron Coderre" wrote:
You might be interested in resolving the basic issue....
Select the range of cells
[Ctrl]+F............shortcut for <edit<find
Find what: *-?...asterisk then a dash then a question mark
Check: Match entire cell contents
Click [Find All]
[Ctrl]+A........To select ALL matched cells
While those cells are selected...
Click the Replace tab
Find what: -........That's just a single dash (-)
Replace with: -0...Dash followed by a zero
UNcheck: Match entire cell contents
Click [Replace All]
Now your list looks like this (and sorts properly)
60000-10
60000-11
60000-12
60000-02
60000-03
60000-04
60000-05
60000-06
60000-07
60000-08
60000-09
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
" wrote:
hi everybody,
my question is as follows, i'll try to explain it using a current
situation I've had.
I've created a semi-numerological list (numbers with other
characters), consisting of the following data:
60000-1
60000-2
60000-3
60000-4
60000-5
60000-6
60000-7
60000-8
60000-9
60000-10
60000-11
60000-12
If you let excel sort this dataset (even if you format the cells as
numbers), it sorts as follows:
60000-1
60000-10
60000-11
60000-12
60000-2
60000-3
60000-4
60000-5
60000-6
60000-7
60000-8
60000-9
Is there a way to let excel sort this dataset correctly (as the top
list, that means)?
thanks in advance,
Leon van Gurp
|