Dear Excel Gurus,
I need someone to help me in solving the below issue in Excel
I have an IP Range 192.168.1.0 /28 (255.255.255.240)
Since the above IP address has 16 logical addresses, i need them to be created automatically in the below form
192.168.1.0
192.168.1.1
192.168.1.2
192.168.1.3
192.168.1.4
192.168.1.5
192.168.1.6
192.168.1.7
192.168.1.8
192.168.1.9
192.168.1.10
192.168.1.11
192.168.1.12
192.168.1.13
192.168.1.14
would appreciate help on the above requirement
Bookmarks