sorting logical lists

  • Thread starter Thread starter leonliev
  • Start date Start date
L

leonliev

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
 
On Jul 11, 1:24 pm, (e-mail address removed) wrote:

Is there a way to let excel sort this dataset correctly (as the top
list, that means)?
Click to expand...

That sounds like a question for an Excel newsgroup really... have you
tried asking there?

Jon
 
As others have pointed out, this is an excel question, and you would
probably have better luck in an Excel group.

However, this is a general problem-solving issue. Excel is not doing
the incorrect thing here, since it knows nothing about the format of your
string. It just knows it is text and tries to sort it accordingly.

What you want to do is have two calculated columns, one with the number
on the left, and another with the number on the right. Then, you sort based
on the first number, then the second.
 
Back
Top