Sorting IP Addresses

[cision_eq]

I am trying to sort a spreadsheet based on ip addresses. I cant seem to figure out how here is an example
machine ip address
test1 111.222.222.123
test2 111.222.222.132
test3 111.222.222.111
basically I want to sort on the last 3 digits
any info would be appreciated. thanks
This message was edited by cision_eq on 2002-04-10 06:24

 

[Mark W.]

See http://www.mrexcel.com/board/viewtopic.php?topic=2365&forum=2.

 

[Aladin Akyurek]

On 2002-04-10 06:24, cision_eq wrote:
I am trying to sort a spreadsheet based on ip addresses. I cant seem to figure out how here is an example
machine ip address
test1 111.222.222.123
test2 111.222.222.132
test3 111.222.222.111
basically I want to sort on the last 3 digits
any info would be appreciated. thanks
This message was edited by cision_eq on 2002-04-10 06:24

Lets say that the sample is in A1:B3.

In C1 enter and copy down:

Change the formula to:

=RIGHT(B1,LEN(B1)-LEN(SUBSTITUTE(B1,".","")))+0

Then sort on column C.

Aladin
This message was edited by Aladin Akyurek on 2002-04-10 06:51

 

[Mark W.]

=RIGHT(B1,LEN(B1)-LEN(SUBSTITUTE(B1
This message was edited by Aladin Akyurek on 2002-04-10 06:51

Aladin, this formula won't work for...

111.222.222.12

 

[aroberge]

There's a good Excel spreadsheet tool that has a function to convert IP addresses to decimal numbers. Once that's done sorting is very easy.