Distribute the number in integer form

[Rajendra_kodavaty]

Hi all,

I have the following problem.

I have a set of number(Batches) ranging from 1 to 12, not in particular order.
I want to distribute the batches to different months with one batch every month


I have close to 100 batches ranging from (1 to 12) to distribute among 12 months.
Please note that the formula or macro must be applied to only selected cells but no the whole sheet

[shukla.ankur281190]

Assuming

A1=1, A2=2 and so on
then
B1=IF(COLUMNS($B$1:B1)<=$A1,1,"") and drag towards the cell and down!!!

[Rajendra_kodavaty]

Hey Ankur,

Thanks for the reply.

I have the numbers in column A ranging from (1-12) more like the below pic. Please don't assume "A1=1,A2=2....A12=12"

I have random numbersCapture.JPG

[shukla.ankur281190]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Phuocam]

I have random numbers

Try this ...

=RANDBETWEEN(1,12)

[Rajendra_kodavaty]

Hey Ankur,

I have attached current and desired files

[Rajendra_kodavaty]

Try this ...

=RANDBETWEEN(1,12)

Please go through the workbooks i have attached

[shukla.ankur281190]

tRY

d3=IF(COLUMNS($D$3:D3)<=$C3,1,"")

[Crooza]

Try this in D3 and drag across and then down to fill the matrix

=IF(MONTH("1/"&D$2&"/2016")<=$C3,1,"")

[Rajendra_kodavaty]

It worked!! thanks a ton