#1
|
|||
|
|||
Spread whole number across specific months in a year
Hi
Is it possible to spread whole numbers (not decimals) across a year? For example if I have a total of 33 and I want to spread it from January to August the formula should give the below result. J F M A M J J A S O N D 4 4 4 4 4 4 4 5 If 33 is spread evenly from January to December it would look like this: J F M A M J J A S O N D 2 2 2 3 3 3 3 3 3 3 3 3 With larger numbers skewed toward the end of the year. I have attached a file with the layout in excel and the expected totals the formula should give for each month. I have been working on this all day but haven't gotten anywhere! You can see in Sheet 2 my previous attempts if it helps. Any help I get I will be eternally grateful for! MonthSpread.xlsm Cheers, Russell |
#2
|
|||
|
|||
Can I pay someone?
Can I pay someone to solve this for me? I tried contacting a few freelance excel workers, but they haven't replied.
|
#3
|
||||
|
||||
I'm assuming you have some other code that loops through the rows and all you're after is the basic logic for working out the #s to populate the 'spread' range. The following code shows how to do that, taking a value entered in an InputBox as the # to spread and the selected range as the cells over which the spreading is to be done:
Code:
Sub Demo() Dim i As Long, j As Long, k As Long, l As Long, x As Long i = CLng(InputBox("Number to spread?", , 0)) j = Selection.Cells.Count k = -Int(-i / j) l = k * j - i For x = 1 To l Selection.Cells(x).Value = k - 1 Next For x = l + 1 To j Selection.Cells(x).Value = k Next End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Counting Number of Months from a static date | bremen22 | Excel | 4 | 11-25-2013 11:57 AM |
Converting serial number to years, months and days | hannu | Excel | 6 | 02-14-2013 09:21 PM |
How to count year lapse (rounded off) based on specific date | KIM SOLIS | Excel | 1 | 11-01-2011 10:50 AM |
Creative Ways for a year-to-year comparison??? | ridonkulous5 | Excel | 1 | 03-23-2011 04:49 PM |
Setting up recurring months to skip some months etc. | dwelch@ykfireprevention.c | Outlook | 0 | 11-30-2010 10:15 AM |