List All Numbers in a Given Range

  • Thread starter Thread starter david.holley
  • Start date Start date
D

david.holley

I rarely use Excel, so I'm not sure if this is possible.
How can I generate an automatic listing of all numbers in a given
range (i.e.: 0 - 255) as values in cells (i.e.: A1 = 1, A2 = 2, A3 =
3, etc.)? I've searched the internet for a while, but can't find a
mention of this anywhere.

I need to do this for about 10 different IP address ranges, but don't
want to have to list each number individually.
I also don't use Usenet often, so if I need to clarify, please let me
know. Thanks.
 
Place this in any starting cell, say in B2, copy down as far as required:
=IF(ROWS($1:1)-1>255,"",ROWS($1:1)-1)
 
Hi,
Or just put 1 in the first cell, 2 in the second cell, then select both
cells and copy down until you hit 255
Dave.
 
Place this in any starting cell, say in B2, copy down as far as required:
=IF(ROWS($1:1)-1>255,"",ROWS($1:1)-1)
Click to expand...

Worked like a charm. Thank you very much......
 
Back
Top