Repeat Cell Data in Ranges
Sean, I might've phrased my question wrong. I am trying to have all these
cells (1,1,1,...2,2,2,2....3,3,3,3,3) repeated 50 times for each number all
in one column going down (say column A).
"Sean Timmons" wrote:
Well, a thought would be to go 1 to 83 as a fill, then copy and paste it.
50*83 = 4150 cells long... Then, just sort by the column...
"Alain" wrote:
I know how to autofill in Excel but haven't been able to autofill 1,1,1,1,(up
to 50 row cells) and then 2,2,2,2 (for the next 50 cells), then 3,3,3,3 and
so forth up to 83,83,83,83,.... In other words, I want that sequence to
increase by 1 every 50 cells from number 1 to 83. Any help with this would be
greatly appreciated.
|