Results 1 to 7 of 7

Week over week Match-Index Help

Threaded View

  1. #1
    Registered User
    Join Date
    07-25-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    4

    Week over week Match-Index Help

    I need to have the Totals column in the % change for week over week automatically take the last two weeks when I insert a new week. I'm using the Index-Match w/ Max function. For ex, Row 5, I have the correct answers. Row 6 uses the index formula, which is computing incorrectly. I cannot find where it is wrong. Please help.

    The spreadsheet is attached. Thank you in advanced!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. UserForm with that shows Previous Week Data and allows you to update current week
    By hicks1ch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-22-2014, 09:47 AM
  2. [SOLVED] excel hlep to calculate the week no from dispatch to closed calls week wise
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-05-2013, 04:53 AM
  3. How to: identify repeat offenders within a 3 week period (week per week basis)
    By Heloc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2012, 12:43 AM
  4. [SOLVED] Index - results in the last week/following week from 2 tabs
    By coreycolman in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-07-2012, 05:05 PM
  5. Replies: 2
    Last Post: 03-16-2012, 08:04 AM

Tags for this Thread

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