sorting logical lists

[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

 

[Jon Skeet [C# MVP]]

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)?

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

Jon

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

hi everybody,

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

Is this in excel ?
IF so you are in thr wrong group.

Post back if you are really doing this in C#

 

[Nicholas Paldino [.NET/C# MVP]]

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.