sorting excel data
one method would be to copy the column of data paste it to the right of data
set with common rows. select the new column and data-text to column and use
"-" as your delimiter.
select all and sort on the two new columns
you could also write a macro if you have to do it very often
" 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
|