If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
IP address sorting in excel
I am looking to sort IP address's in excel not being the
best excel user is ther an easy way to do this? the format fot those of you who might not be familar it is a range of numbers from 192.168.3.1-192.168.3.254 . I would lik for it to give me the address in a numericle order. Any suggestions? |
#2
|
|||
|
|||
IP address sorting in excel
You can find a bunch of suggestions by searching the archives (use "IP
Sort," without quotes, as a key): http://groups.google.com/advanced_gr...=group:*excel* David McRitchie has an excellent suggestion he http://www.mvps.org/dmcritchie/excel/sorttcp.htm In article , "Shaun Haines" wrote: I am looking to sort IP address's in excel not being the best excel user is ther an easy way to do this? the format fot those of you who might not be familar it is a range of numbers from 192.168.3.1-192.168.3.254 . I would lik for it to give me the address in a numericle order. Any suggestions? |
#3
|
|||
|
|||
IP address sorting in excel
Shaun
one option: http://www.mofunzone.com/downloadsof...00036593.shtml Regards Trevor "Shaun Haines" wrote in message ... I am looking to sort IP address's in excel not being the best excel user is ther an easy way to do this? the format fot those of you who might not be familar it is a range of numbers from 192.168.3.1-192.168.3.254 . I would lik for it to give me the address in a numericle order. Any suggestions? |
Thread Tools | |
Display Modes | |
|
|