filling column with n sets of numbers
Posted by steve on September 09, 2001 8:57 PM
I want to fill a column with n sets of numbers e.g. starting with the number '1' in A1, fill the first n rows with '1', the next n rows with '2' and so on until some end value I specify e.g. stop after the 60th iteration, so I end up with a column that contains the numbers 1-60, each repeated n times. I can't work out how to do this using 'Series'. Am I mssing something?