Repeat text a number define of times
 

Hi,

I want to repeat diferent names a number of times in diferent cells, for
example:

names number
bad 3
medium 9
good 3


A1

bad
bad
bad
medium
medium
medium
medium
medium
medium
medium
medium
medium
good
good
good



My dificult is that when I change the number of names, I want that this
writes the text the new number of times automatically.

Any suggestions?

Thanks in advance,
Alexandra

Repeat text a number define of times
 

Say your table <names, number below is located in A1:B4 (A1="names",
A2="bad"). You will build an auxiliary column in C:C. In C2 enter the
number 1. In C3 formula to copy down:

=C2+B2

Now say you want to start the repeating values in F2. Use the
following formula in F2:

=IF(ROWS($F$2:F2)<=SUM($B$2:$B$4),INDEX($A$2:$A$4, MATCH(ROW()-ROW($F
$2)+1,$C$2:$C$4,1)),"")

You can copy down this formula and it will exhaust your table and
afterwords leave blank cells.

HTH
Kostis Vezerides

On Nov 18, 5:22*pm, Alexandra Lopes wrote:
Hi,

I want to repeat diferent names a number of times in diferent cells, for
example:

names * number
bad * * 3 * * *
medium *9
good * *3

A1

bad
bad
bad
medium
medium
medium
medium
medium
medium
medium
medium
medium
good
good
good

My dificult is that when I change the number of names, I want that this
writes the text the new number of times automatically.

Any suggestions?

Thanks in advance,
Alexandra

Repeat text a number define of times
 

Hi,

I have copied the formula, but it returns an error:

"The formula you typed contains an error"

Can you help me, please?

Thanks,

Alexandra




vezerid wrote:
Say your table <names, number below is located in A1:B4 (A1="names",
A2="bad"). You will build an auxiliary column in C:C. In C2 enter the
number 1. In C3 formula to copy down:

=C2+B2

Now say you want to start the repeating values in F2. Use the
following formula in F2:

=IF(ROWS($F$2:F2)<=SUM($B$2:$B$4),INDEX($A$2:$A$4, MATCH(ROW()-ROW($F
$2)+1,$C$2:$C$4,1)),"")

You can copy down this formula and it will exhaust your table and
afterwords leave blank cells.

HTH
Kostis Vezerides

On Nov 18, 5:22 pm, Alexandra Lopes wrote:
Hi,

I want to repeat diferent names a number of times in diferent cells, for
example:

names number
bad 3
medium 9
good 3

A1

bad
bad
bad
medium
medium
medium
medium
medium
medium
medium
medium
medium
good
good
good

My dificult is that when I change the number of names, I want that this
writes the text the new number of times automatically.

Any suggestions?

Thanks in advance,
Alexandra

Repeat text a number define of times
 

Don;t copy the formula as it is, it depends on where exactly you have
the original table. The tricky parts in the formula are $A$2:A$A4, $B
$2:$B$4 and $C$2:$C$4. Of these, A2:B4 are supposed to contain {bad,
3; medium, 9; good, 3} and C2:C4 contain the 1 and the formula I
suggested for the auxiliary cells.

If your table is in other cells you must modify these parts
accordingly.

HTH
Kostis

On Nov 18, 6:50*pm, Alexandra Lopes wrote:
Hi,

I have copied the formula, but it returns an error:

"The formula you typed contains an error"

Can you help me, please?

Thanks,

Alexandra

vezeridwrote:
Say your table <names, number below is located in A1:B4 (A1="names",
A2="bad"). You will build an auxiliary column in C:C. In C2 enter the
number 1. In C3 formula to copy down:

=C2+B2

Now say you want to start the repeating values in F2. Use the
following formula in F2:

=IF(ROWS($F$2:F2)<=SUM($B$2:$B$4),INDEX($A$2:$A$4, MATCH(ROW()-ROW($F
$2)+1,$C$2:$C$4,1)),"")

You can copy down this formula and it will exhaust your table and
afterwords leave blank cells.

HTH
Kostis Vezerides

On Nov 18, 5:22 pm, Alexandra Lopes wrote:
Hi,

I want to repeat diferent names a number of times in diferent cells, for
example:

names * number
bad * * 3 * * *
medium *9
good * *3

A1

bad
bad
bad
medium
medium
medium
medium
medium
medium
medium
medium
medium
good
good
good

My dificult is that when I change the number of names, I want that this
writes the text the new number of times automatically.

Any suggestions?

Thanks in advance,
Alexandra

Repeat text a number define of times
 

Hi,

I have copied the formula but it doesn't work..in F2 apears the formula
and not any result..I'm using Excel 2007..I don't know if it doesn't
matter..

Could you help me please?

Thanks,

Alexandra



vezerid wrote:
Say your table <names, number below is located in A1:B4 (A1="names",
A2="bad"). You will build an auxiliary column in C:C. In C2 enter the
number 1. In C3 formula to copy down:

=C2+B2

Now say you want to start the repeating values in F2. Use the
following formula in F2:

=IF(ROWS($F$2:F2)<=SUM($B$2:$B$4),INDEX($A$2:$A$4, MATCH(ROW()-ROW($F
$2)+1,$C$2:$C$4,1)),"")

You can copy down this formula and it will exhaust your table and
afterwords leave blank cells.

HTH
Kostis Vezerides

On Nov 18, 5:22 pm, Alexandra Lopes wrote:
Hi,

I want to repeat diferent names a number of times in diferent cells, for
example:

names number
bad 3
medium 9
good 3

A1

bad
bad
bad
medium
medium
medium
medium
medium
medium
medium
medium
medium
good
good
good

My dificult is that when I change the number of names, I want that this
writes the text the new number of times automatically.

Any suggestions?

Thanks in advance,
Alexandra

Repeat text a number define of times
 

suppose in cell A1 has word Bad and cell B1 has 3 in cell C1 put this
formula and drag it

=IF($A$1<"",IF(((ROW($A$1)-1)+$B$1)=ROW(B1),$A$1,""))



On Nov 18, 8:22*pm, Alexandra Lopes wrote:
Hi,

I want to repeat diferent names a number of times in diferent cells, for
example:

names * number
bad * * 3 * * *
medium *9
good * *3

A1

bad
bad
bad
medium
medium
medium
medium
medium
medium
medium
medium
medium
good
good
good

My dificult is that when I change the number of names, I want that this
writes the text the new number of times automatically.

Any suggestions?

Thanks in advance,
Alexandra

Repeat text a number define of times
 

Hi,

this results.

Thank you very much!


muddan madhu wrote:
suppose in cell A1 has word Bad and cell B1 has 3 in cell C1 put this
formula and drag it

=IF($A$1<"",IF(((ROW($A$1)-1)+$B$1)=ROW(B1),$A$1,""))



On Nov 18, 8:22 pm, Alexandra Lopes wrote:
Hi,

I want to repeat diferent names a number of times in diferent cells, for
example:

names number
bad 3
medium 9
good 3

A1

bad
bad
bad
medium
medium
medium
medium
medium
medium
medium
medium
medium
good
good
good

My dificult is that when I change the number of names, I want that this
writes the text the new number of times automatically.

Any suggestions?

Thanks in advance,
Alexandra