Results 1 to 8 of 8

Referencing Weekly data from large raw data set

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-13-2008
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    277

    Referencing Weekly data from large raw data set

    Hi Guys,

    I already have had help to produce a formula to reference a large amount of data and pull one month at a time:

    =IF(MONTH(DATE(2008,$E$17,ROWS($A$1:$A2)))<>$E$17,"",INDEX('0091 911'!AI:AI,MATCH(DATE(2008,$E$17,ROWS($A$1:$A2)),'0091 911'!$A:$A,0)))
    I now need to adapt this so it will pull weekly data on another sheet.

    I have attached the workbook beause i find it hard to explain what i mean,

    I basicly want another sheet that i can choose week 1 - 52 and data from seven days will be shown.

    Thanks for all your help!
    Attached Files Attached Files
    Last edited by freud1; 03-08-2009 at 05:53 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