An easy way to convert IPs to decimal so they can be sorted is to use an Excel function to do it. See here<http://topnettricks.com/dns-ip-address-excel-download-free/>for more details.
On Friday, June 24, 2011 5:59:16 AM UTC-4, OpenExcel.com wrote: > > Are you a reporting analyst in IT firm, network engineer, networking > analyst or any one who works on network data? If yes, then you ever tried > to sort TCP/IP Addresses, I'm sure something like red list in this figure, > would have happened and you must have desired the green list. This is the > issue of sorting with delimited numbers like 1.1.2, 1.1.1, 1.1.10 which > results in 1.1.1, 1.1.10, 1.1.2. > > > Generally, computer and languages on which computers operate treat them as > string literals and sorting is based on their ASCII character number. So, > the solution is to normalize them, sort them and denormalize back in their > original form. > > > This is how, the given VBA macro works. Hope, you understand it easily and > leave any questions for clarifications in the comments section. > > > CLICK HERE FOR THE VBA MACRO > CODE<http://www.excelitems.com/2011/06/sort-tcp-ip-address-excel-delimited-vba.html> > > > > Best Regards, > Ashish Jain > Facebook <http://www.facebook.com/eXceLiTems>/ > eXceLiTems<http://www.eXceLiTems.com> > +91 - 9999 - 40 - 48 - 43 > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
