Results 1 to 2 of 2

Monthly Grid Populated using Start Month, End Month, and 3 other potential factors

Threaded View

  1. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2504
    Posts
    19,301

    Re: Monthly Grid Populated using Start Month, End Month, and 3 other potential factors

    Made a couple of changes, highlighted in orange.
    1) Put dates in row 3, then applied the formatting 'mmm' to the cells
    2) Inserted a helper column (A), which may be moved and/or hidden for aesthetic purposes, populated using: =SUM(D$8:D8)
    Then populated row 8 using the array entered formula*:
    Formula: copy to clipboard
    =$C4*INDEX($F5:$Q5,MATCH(MONTH(F7),MONTH($F3:$Q3),0))*INDEX($C9:$C12,MATCH(COUNT($E8:E8),$A9:$A12,1))

    *Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER (BEFORE copying across). You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. start month, end month based on year and period
    By stephme55 in forum Excel General
    Replies: 4
    Last Post: 09-06-2016, 04:56 PM
  2. [SOLVED] Auto instert Month names for This month, Last month and Next month
    By hemal89 in forum Word Programming / VBA / Macros
    Replies: 4
    Last Post: 12-10-2013, 12:01 PM
  3. Replies: 1
    Last Post: 10-29-2013, 02:11 AM
  4. Replies: 0
    Last Post: 08-24-2013, 11:43 AM
  5. Replies: 6
    Last Post: 03-03-2013, 01:41 AM
  6. [SOLVED] calculate pay checks per month, to get monthly income value for that month.
    By tladd in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-20-2012, 09:51 PM
  7. Start month, end month and cost.
    By Ainsley in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-16-2007, 08:41 AM

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