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