Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Excel to auto spread data
Hi,
Is it possible to put in a constant in column A, and Excel can equally spread this constant based on the start & finish dates in column B and C to column D and beyond? How about have the constant spread into a S-curve or different curves? For example, front end loaded early months or load up the later months? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Excel to auto spread data
You would need a macro to do this - a formula can only return a result
to the cell it is in. Hope this helps. Pete On Sep 29, 6:40 pm, JJ wrote: Hi, Is it possible to put in a constant in column A, and Excel can equally spread this constant based on the start & finish dates in column B and C to column D and beyond? How about have the constant spread into a S-curve or different curves? For example, front end loaded early months or load up the later months? Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Excel to auto spread data
For a constant spread based on the number of days within each month that are
also included in your date range you could do something like this: A2 = amount to spread B2 start date C2 end date D1:Z1 dates, 1st of successive months (format as ddd yy, if you wish) in D2 use this formula copied across =MAX(0,MIN($C2+1,E$1)-MAX($B2,D$1))*$A2/($C2-$B2+1) format as number or currency "Pete_UK" wrote: You would need a macro to do this - a formula can only return a result to the cell it is in. Hope this helps. Pete On Sep 29, 6:40 pm, JJ wrote: Hi, Is it possible to put in a constant in column A, and Excel can equally spread this constant based on the start & finish dates in column B and C to column D and beyond? How about have the constant spread into a S-curve or different curves? For example, front end loaded early months or load up the later months? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I look up data in a different workbook in an excel spread. | Excel Worksheet Functions | |||
Auto Adjust Spread Sheet so it will print on 1 page/legal/landscap | Excel Worksheet Functions | |||
Analyzing non numerical data in an excel spread sheet | Excel Worksheet Functions | |||
Analyzing non numerical data in an excel spread sheet | Excel Worksheet Functions | |||
Analyzing non numerical data in an excel spread sheet | Excel Worksheet Functions |