Hi,
I have a list of IP addresses in excel and i want to move all the IP addresses that match the same subnet onto a different column in order to organise them.
e.g.
10.208.1.1
10.208.1.2
10.209.1.1
10.208.1.3
10.209.1.2
I want to move all the 10.209s to different column and leave the 10.208s in the same column. Like this:
10.208.1.1 10.209.1.1
10.208.1.2 10.209.1.2
10.208.1.3
At the moment they are all under one column and they are all mixed up. Would it be possible to write a formula or VBA script to sort these IPs out??
Thanks in advanced,
Kevin
Bookmarks