+ 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
    2010
    Posts
    268

    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
    Valued Forum Contributor Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel365
    Posts
    2,376

    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)

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