Another method, assuming that your colour is in column B from B1
downwards, and the number of required occurances is n column C from C1
downwards, using columns E F and G to create your list in column E:

in E1 put:
=INDIRECT("b"&G1)

in F1 put:
=SUM(C$1:C1)

in G1 put a number 1
in G2 put:
=IF(ROW()INDIRECT("f"&G1),G1+1,G1)

and formula drag columns E F and G to cover the required total of
entries.

when the list is complete you can copy column E and Paste Special =
Values then remove any non-required columns.

HTH




Maven Wrote:
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!


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