filling up cells automatically!!

Hi,

I have the following problem,

I have a two clumn numbers like this,

1 5
2 4
3 8
4 9
5 3
6 2
------
------
------
168 2
169 4.

I want to fillup cels automatically with the numbers of column 1 with the times of corresponding column 2. Example, the number 1 of column should be filled up 5 times (as shown in column 2) like, 1 1 1 1 1 and 2 as 2 2 2 2 and so on. Ofcourse i could do it in perl using for loop. I dont have idea of programming in excel. Can anybody help me.

REPT function will repeat the text or cell value the number of times shown in the second column cell in a single cell only.

like,

1 4 will give 1 4 1111 but i want the repeated 1s should be posted in different cells. Actually my problem is the column one shows an agent id and the column two shows the number of gift coupons he got. we will take a lucky dip and give a bumper gift. for this i want to make lucky coupons on that agent id. from that we will select one agent.

=IF(Column()-2<=$B1,$A1,"") should work. Put this in C1, drag across as many columns as the max number in column B and drag down.

Thank you, but there is a problem in this formula.

1. This is giving one number less repeats than required.
example:
if A1=1 and B1=5. Then A1 should be repeated 5 times, but it is giving 4
times only.

2. It is not giving any result when B=1. (as per your formula it is giving value
B-1 times)...

please modify.

I tested it and it works just fine for me. Did you type < instead of <=?

Nope! I just copied and pasted your formula....ofcourse i even re-wrote that , but it is giving 1 less... and no result when b=1. I am using excel-2007.

Could you please post your workbook then? Please save it as an xls, then zip it.