Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Amplifying Dana DeLouis' solution...The following method works great. You need 6 columns, but can sort on only one.
Let's say A2 contains the IPv4 address in normal non-zero-filled format like "192.168.15.42". In B2 enter the formula: =split(A2,".") which puts the four numeric address terms in columns B2, C2, D2 and E2. Then in F2 enter =4294967296*B2+65536*C2+256*D2+E2 For example, IP 192.168.15.42 generates an "IP sort" number 824644734762. Copy the two formulas down their respective columns, call column E "IPsort" or some such and sort ascending on just this column. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to sort names in alphabetical ascending order? | Excel Discussion (Misc queries) | |||
How to sort worksheets in alphabetical order (descending or ascending)? | Excel Discussion (Misc queries) | |||
How do I arrange/sort worksheets in ascending order? | Excel Discussion (Misc queries) | |||
Excel worksheets needs to sort ascending or descending order. | Excel Worksheet Functions | |||
Sort Data Into Numerical Order..! | Excel Discussion (Misc queries) |