View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alexandra Lopes Alexandra Lopes is offline
external usenet poster
 
Posts: 35
Default 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