Sorting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kim - 03 Dec 2006 00:29 GMT

I have a problem sorting in Excel. When I try to sort my list in Excel it
sorts like this:

1.1.1
1.1.11
1.1.2
11.1.1
2.1.1

I would like it to sort like this:
1.1.1
1.1.2
1.1.11
2.1.1
11.1.1

Is that possible?

Signature

Kim

Reply to this Message

Jim Cone - 03 Dec 2006 03:02 GMT

See this post from 1998 on sorting IP addresses...
http://tinyurl.com/y6696s
Especially the one from Dana at the bottom of the page.

Signature

Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html

"Kim" <Kim@discussions.microsoft.com>
wrote in message
I have a problem sorting in Excel. When I try to sort my list in Excel it
sorts like this:

1.1.1
1.1.11
1.1.2
11.1.1
2.1.1

I would like it to sort like this:
1.1.1
1.1.2
1.1.11
2.1.1
11.1.1

Is that possible?
--
Kim

Reply to this Message

David McRitchie - 11 Dec 2006 04:03 GMT

I don't think you really want to use Text to Columns,
and then sort on three columns. The following will
work even though most IP addresses have four nodes,
the sort will aligned on left though for normalized numbers.
I think if you had a mix of 3 nodes and 4 nodes you would
not get what you want.

see Sorting TCP/IP Addresses, and the like
http://www.mvps.org/dmcritchie/excel/sorttcp.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> See this post from 1998 on sorting IP addresses...
> http://tinyurl.com/y6696s
> Especially the one from Dana at the bottom of the page.

Reply to this Message

Rate this thread: