Results 1 to 7 of 7

Incremental Division [Almost there]

Threaded View

kgibson20 Incremental Division [Almost... 02-28-2012, 12:01 PM
ChemistB Re: Incremental Division 02-28-2012, 12:12 PM
kgibson20 Re: Incremental Division 02-28-2012, 12:21 PM
ChemistB Re: Incremental Division 02-28-2012, 12:36 PM
kgibson20 Re: Incremental Division 02-28-2012, 01:00 PM
kgibson20 Re: Incremental Division 02-28-2012, 01:03 PM
kgibson20 Re: Incremental Division 02-28-2012, 01:08 PM
  1. #1
    Registered User
    Join Date
    01-29-2008
    Posts
    68

    Incremental Division [Almost there]

    I have hours in columns extended out several years by month. For this example it starts at A1. In another spreadsheet I have those months split with 2 dates for every month. What I need to do is to come up with a formula that will allow me to divide each month evenly to spread across the 2 dates for the correlating month on the spreadsheet with two dates for each month. I have hundrunds of line items that span over 10 years so a formula will help tremendously. Also, if someone has a better recommendation for a title of this thread please let me know.


    January-12 February-12 March-12 April-12
    100 100 100 100
    1/8/2012 1/26/2012 2/10/2012 2/23/2012 3/6/2012 3/20/2012 4/10/2012 4/28/2012
    50 50 50 50 50 50 50 50
    Last edited by kgibson20; 02-28-2012 at 01:35 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1