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
|