Results 1 to 5 of 5

Data Lookup for Last 4 Weeks

Threaded View

distortthecode Data Lookup for Last 4 Weeks 12-04-2014, 08:56 AM
samba_ravi Re: Data Lookup for Last 4... 12-04-2014, 09:15 AM
distortthecode Re: Data Lookup for Last 4... 12-04-2014, 01:09 PM
Haseeb Avarakkan Re: Data Lookup for Last 4... 12-04-2014, 01:38 PM
distortthecode Re: Data Lookup for Last 4... 12-05-2014, 07:57 AM
  1. #1
    Registered User
    Join Date
    03-06-2014
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    34

    Data Lookup for Last 4 Weeks

    I'm currently trying to figure out a way that will allow me to compare data from the last week vs the last 4 weeks prior. It also has to be possible to choose an older week and look at the four weeks prior to that date as well.

    I have created a dummy version of how I would (ideally) want it to appear with some dummy data but I have no idea how to be able to do it - I'm not able to use Pivot tables in this instance.

    Data Lookup Question.xlsx
    Last edited by distortthecode; 12-04-2014 at 08:58 AM. Reason: Wrong attachment

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculate and lookup last weeks total hours worked from a table without #N/A error message
    By thetaplus in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-18-2014, 03:54 AM
  2. Dividing monthly values into weeks automatically (some months have 5 weeks)
    By massimoo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-07-2012, 03:20 AM
  3. difference between two dates in working weeks(5 day weeks)
    By AWilderbeast in forum Excel General
    Replies: 3
    Last Post: 08-31-2010, 09:21 AM
  4. Calculating Averages based upon weeks not include Bye Weeks
    By Kfetterman1 in forum Excel General
    Replies: 2
    Last Post: 09-27-2006, 11:18 AM
  5. Turn excel weeks into finacial weeks
    By dragonfly in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-20-2005, 10:07 PM

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