Results 1 to 11 of 11

lookup values by date

Threaded View

  1. #1
    Registered User
    Join Date
    11-28-2012
    Location
    bozeman, MT
    MS-Off Ver
    Excel 2003
    Posts
    3

    lookup values by date

    I have a spreadsheet I'm trying to figure out the formula for.....

    The spreadsheet include an account#, name of a trade show, the date of the trade show, and then every single month for the past 2 years or so. Under each month it tells me how many orders that particular account number has placed for that month. I would like to know see how many orders each account placed 3 months before show date, 3 months after show date, 6 months before show date, 6 months after show date, 12 months before show date, 12 months after show date.

    For example the Show ASI Chicago 2009 took place 07/01/2009. See how many orders the account number ALLE43077 placed 3 months before 07/01/2009 (April 2009, May 2009 and June 2009) total into one cell, 3 months after 07/01/2009 (August 2009, September 2009 and October 2009) totaled into one cell
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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