how can you generate a list of numbers in Microsoft Excel? Eg 111 222 333, etc?

Question

I wanted to generate a list of numbers in excel, but repeating numbers in one column.

For example:
Column A
1
1
1
2
2
2
3
3
3
4
4
4
5
5
5

Answer 1

A few ways using the ROW() function:



=QUOTIENT(ROW() + 2, 3)



=TRUNC((ROW() + 2) / 3)



=ROUNDUP(ROW() / 3, 0)



If you are starting in a different row, adjust the +2 as needed. Be warned that moving the cells will cause the values to readjust to their new position; you should 'paste values' instead.

Answer 2

Put a 1 in A1, A2, and A3. In cell A4, put



=A1+1



After you've entered the formula in A4, move the cursor over the bottom right of A4, and when the cursor changes to a solid plus sign, hold down the left mouse button and drag down as far as needed. If you are going to have thousands of cells, first copy A4, then in the name box (it's just to the left of the formula bar, type A4:A6000 and press Enter. This will select A4:A6000. Now click the paste button.

Answer 3

In Microsoft Excel variety a million in 1st column, then 2 in next coumn and 3 in third column vertically. Now elect 1st, 2d and third column having a million,2,3 you typed as above. Drag and drop the properly suited end of the chosen oblong field vertically, you will get the record of numbers in increasing order. Drag the selection upto the column selection 674 or have been given the 674 selection interior the column fee. wish this could do :-)

Answer 4

Start your column A with

1

1

1



Then in the next cell paste this formula:

=IF(AND(A3=A2,A2=A1),A3+1,A3)



Drag the corner down as far as you like to copy.



To change from formulas to numbers, copy the column and then PASTE > SPECIAL > VALUES.



. .