sorting logical lists

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

leonliev@gmail.com - 11 Jul 2007 13:24 GMT

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

Reply to this Message

Jon Skeet [C# MVP] - 11 Jul 2007 13:26 GMT

On Jul 11, 1:24 pm, leonl...@gmail.com wrote:

<snip>

> 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

Reply to this Message

Ignacio Machin ( .NET/ C# MVP ) - 11 Jul 2007 15:16 GMT

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#

Reply to this Message

Nicholas Paldino [.NET/C# MVP] - 11 Jul 2007 16:41 GMT

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.

Signature

- Nicholas Paldino [.NET/C# MVP]
- mvp@spam.guard.caspershouse.com

> hi everybody,
>
[quoted text clipped - 38 lines]
> thanks in advance,
> Leon van Gurp

Reply to this Message

sorting logical lists

Free Magazines