Formula to copy 1 cell by number in another

Solved/Closed

tanz25 Posts 4 Registration date Tuesday July 13, 2010 Status Member Last seen July 14, 2010 - Jul 12, 2010 at 11:58 PM
tanz25 Posts 4 Registration date Tuesday July 13, 2010 Status Member Last seen July 14, 2010 - Jul 14, 2010 at 05:34 PM

I have a spread sheet with text and numbers in a1 to c1 and then in d1 is a number that i need it copy and pasted by

E.G

Hello 3
Stuff 6
hannah 2

I need 3x hello 6x stuff 2xhannah however in my spread sheet that i need done i have about 3000 records i need this done for

Any one know how to do this.

Hope this makes senses

Suppose cell c5 contains the formula =b$6+c1. match each formula with its respective cell if you copied it.
Count if cell contains number - Excel Forum
Position formula in excel ✓ - Office Software Forum
Excel formula if cell contains text then return value in another cell ✓ - Excel Forum
Logitech formula vibration feedback wheel driver - Download - Drivers
Date formula in excel dd/mm/yyyy - Guide

2 responses

Answer 1 / 2

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 13, 2010 at 09:51 PM

see this

https://ccm.net/forum/affich-333050-how-to-repeat-rows-by-x-number-of-times

tanz25 Posts 4 Registration date Tuesday July 13, 2010 Status Member Last seen July 14, 2010
Jul 13, 2010 at 10:15 PM

unfortunately this doesn't make since to me

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 14, 2010 at 05:12 PM

That's a macro that does 100% exactly what you seek

tanz25 Posts 4 Registration date Tuesday July 13, 2010 Status Member Last seen July 14, 2010
Jul 14, 2010 at 05:34 PM

Thank you i have figured out how to use this now.

Answer 2 / 2

Trowa
Jul 13, 2010 at 09:03 AM

Hi Tanz,

If I understand you correctly you would like cell D1 to be like this:
Hello Hello Hello Stuff Stuff Stuff Stuff Stuff Stuff hannah hannah

First you need to split your data into two columns. Go to top menu Data > Text to columns (or delimiter) and follow on screen directions.

Now use this formula in D1:
=REPT(A1 & " ",B1) & REPT(A2 & " ",B2) & REPT(A3 & " ",B3)

Is this the result you were looking for?

Best regards,
Trowa

tanz25 Posts 4 Registration date Tuesday July 13, 2010 Status Member Last seen July 14, 2010
Jul 13, 2010 at 02:41 PM

This is very close to what i need except i need it to be in separate cells
so i need it to be
Hello
hello
hello
Stuff
Stuff
Stuff
Stuff
Stuff
Stuff
Hannah
Hannah

Similar discussions

What is my confirmation code for Facebook?

My laptop n,b,space,2,? mark keys not working

Some keys stopped working i.e.B, N, Space, Arrows

Laptop some keys on my keyboard are not working

laptop b,n, space bar,arrow keys are not working

Auto insert 'x' rows depending on value 'y'

Similar discussions

Subscribe To Our Newsletter!