Is there a way I can use a number in a cell to fill in that number of
cells with a given value? For example, is there a way that I could
enter this kind of information:

Number blue 3
Number red 2

And get this returned to me:

Blue
Blue
Blue
Red
Red

Any suggestions would be appreciated!


--
Maven
------------------------------------------------------------------------
Maven's Profile: http://www.excelforum.com/member.php...o&userid=37826
View this thread: http://www.excelforum.com/showthread...hreadid=573870