incrementing
i would like to make a list of IP's going from 172.16.1.0-172.16.1.254, is
there a formula that will increment this to save me time? i need to type about 3000+ addresses. please help.. |
incrementing
Hi
Just type the first one in a cell, then the second one in the cell beneath. Mark both cells, and use the fill handle at the bottom right of the pair of cells to fill down as far as you wish. The end number will step up sequentially. -- Regards Roger Govier "luuthur" wrote in message ... i would like to make a list of IP's going from 172.16.1.0-172.16.1.254, is there a formula that will increment this to save me time? i need to type about 3000+ addresses. please help.. |
incrementing
NO formula needed!
Just enter your first number, Click on the fill handle, And drag down to copy as needed. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "luuthur" wrote in message ... i would like to make a list of IP's going from 172.16.1.0-172.16.1.254, is there a formula that will increment this to save me time? i need to type about 3000+ addresses. please help.. |
incrementing
OMG, TYSM this is going to save alot of time... i hope to learn more about
these programs.. thanks again.. "Roger Govier" wrote: Hi Just type the first one in a cell, then the second one in the cell beneath. Mark both cells, and use the fill handle at the bottom right of the pair of cells to fill down as far as you wish. The end number will step up sequentially. -- Regards Roger Govier "luuthur" wrote in message ... i would like to make a list of IP's going from 172.16.1.0-172.16.1.254, is there a formula that will increment this to save me time? i need to type about 3000+ addresses. please help.. |
incrementing
If you want to save some typing.................
enter the first IP in the cell then right-click and drag. Release the mouse button and "Fill Series" But..........172.16.1.0-172.16.1.254 is only 254 addressess. What will you do after 172.16.1.254 and after 172.16.1.999 ? Gord Dibben MS Excel MVP On Tue, 22 May 2007 18:58:03 -0700, luuthur wrote: OMG, TYSM this is going to save alot of time... i hope to learn more about these programs.. thanks again.. "Roger Govier" wrote: Hi Just type the first one in a cell, then the second one in the cell beneath. Mark both cells, and use the fill handle at the bottom right of the pair of cells to fill down as far as you wish. The end number will step up sequentially. -- Regards Roger Govier "luuthur" wrote in message ... i would like to make a list of IP's going from 172.16.1.0-172.16.1.254, is there a formula that will increment this to save me time? i need to type about 3000+ addresses. please help.. |
All times are GMT +1. The time now is 07:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com