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