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