Hi

I have an array of values as follows

3 25
1 10
4 12
6 7

the first column represents the number of instances of the row. I
would like to convert this as follows:

25
25
25
10
12
12
12
12
7
etc.

how can I do this formulaically? or formulaically with a UDF?

thanks


--
newengland
------------------------------------------------------------------------
newengland's Profile: http://www.excelforum.com/member.php...fo&userid=5946
View this thread: http://www.excelforum.com/showthread...hreadid=490855