# how to copy 2 numbers and have it repeat for 100 times

1. ## how to copy 2 numbers and have it repeat for 100 times

In a column, i have the numbers 4,2 and i need it to repeat for 100 rows in the same pattern

4
2
4
2
4
2
4
2

what is the fastest way to copy and paste that or fastest way to accomplish this? this numbers will be used in multiplication IE

4 3
2 5
4 2
2 9

so next to it will be the product

4 3 12
2 5 10

etc
etc

thanks

2. ## Re: how to copy 2 numbers and have it repeat for 100 times

Enter 4 into A1 and 2 into A2, then in A3 you can use this formula:

=A1

Copy this down column A up to A100 (or A200, if you mean you want each number 100 times).

Hope this helps.

Pete

3. ## Re: how to copy 2 numbers and have it repeat for 100 times

Awesome, so simple. thank you. I am doing a numerical methods calculation and i needed to know how to do that.

4. ## Re: how to copy 2 numbers and have it repeat for 100 times

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

5. ## Re: how to copy 2 numbers and have it repeat for 100 times

done and done

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1