In Excel, How do I create a list with duplicate numbers?

In cells A1 and A2 enter the number 1

In cell A3 enter this formula:

=A1+1

Copy A3 down as far as you need.

I suppose you could use the RAND function, and use that to create a list of random numbers.

For example, say you wanted numbers in the range of 1 to 10. Enter this in cell a1, and then copy and paste down for a few dozen rows:

=INT(RAND()*(10-1)+1)

That will give you a list with numbers from 1 to 10. You most certainly will have some duplicates. You could them sort the list, if needed.

Another way is to just type in random numbers yourself, in a column! Be sure to use the same number more than once. Done! You've created a list with duplicate numbers!

It would help if you explained why you wanted such a list.

Edit: From your e-mail message to me, this macro will create the pattern show above, from 1 to 800.

Sub test()

Row = 1: Col = 1

For x = 1 To 800

Cells(Row, Col) = x

Cells(Row + 1, Col) = x

Row = Row + 2

Next

End Sub

Excel can recognize a series with blank rows in between:

1

{blank}

2

{blank}

Select those four cells and drag the Fill handle to make the series. Then copy the series, move down one cell, and Paste Special > Add.

This formula can also help, starting in row 1:

=ROUNDUP(ROW() / 2, 0)

You can adjust the math so it works with other starting rows.

Try this in A2 type 1.

In A3 put =IF(A2<>A1,A2,A2+1) drag cells down as far as you want.