Repeat text a number define of times

[Alexandra Lopes]

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

 

[vezerid]

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

 

[Alexandra Lopes]

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]

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

 

[Alexandra Lopes]

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

 

[muddan madhu]

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,""))

 

[Alexandra Lopes]

Hi,

this results.

Thank you very much!

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,""))