+ Reply to Thread
Results 1 to 2 of 2

Lookup and compare customer demand based on rolling dates….

  1. #1
    Forum Contributor
    Join Date
    04-06-2017
    Location
    Wolverhampton
    MS-Off Ver
    Office 365
    Posts
    471

    Lookup and compare customer demand based on rolling dates….

    Hello All

    i need somthing to comapare customer demand change, so i can quickly see what increases and decreased from day to day

    please see attahed

    Yellow tabs data is pasted in on that particular day, the days demand always appears as ‘Today’ so on Wednesday 15/5/2019 = Today
    Wed & Thur tab
    This is all the possible part number my customer can order

    I want this to compare Wednesdays and Thursday data by looking at the dates, keeping in mind 16/05/2017 that appears on Wednesday tab will show as ‘today’ on Thursdays tab


    thanks for your time

    Paul
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Lookup and compare customer demand based on rolling dates….

    Please try at Wed & Thur G5
    =IFERROR(INDEX('Wednesday '!H$2:H$99,MATCH($A8,'Wednesday '!$A$2:$A$99,))-INDEX('Thursday '!G$2:G$99,MATCH($A8,'Thursday '!$A$2:$A$99,)),0)
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Working out replenishing levels from customer demand using a Maximum Stock level
    By pmw19800 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-25-2018, 09:02 AM
  2. Create a rolling 30 day average based on dates in heading.
    By jumper121187 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-16-2014, 10:16 PM
  3. Replies: 1
    Last Post: 03-22-2014, 08:10 AM
  4. Rolling formula based on dates
    By Janie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-17-2013, 01:07 PM
  5. Macro for showing tabs based on rolling dates
    By a_dub_green in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2012, 11:33 AM
  6. Look Up customer information based on dates
    By Georgia Golfer in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-09-2009, 01:53 PM
  7. Replies: 1
    Last Post: 07-25-2006, 05:29 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