+ Reply to Thread
Results 1 to 3 of 3

CHALLENGE - Extract data from a table with multiple conditions....

  1. #1
    Registered User
    Join Date
    10-16-2014
    Location
    England
    MS-Off Ver
    Excel 2002
    Posts
    2

    CHALLENGE - Extract data from a table with multiple conditions....

    Hello,

    I am looking to create a new Service report at work. Our system extracts a list of customers with a list of products and then gives the order/dispatch quantity over the next week.

    I want to create a summary sheet which will look all the entries for Customer A on Monday and total all the cases of products dispatched on that day. Then obviously copy across for the remaining days of the week.

    I may need to add several other conditions but at the moment in column A is the Customer, Column B the product and then across the top row we have the days of the week in Sunday-Saturday.

    Formulas such as Sumproduct, Index-Match, SUMIF has been tried but keep pulling NA or VALUE entries and im going abit crazy!

    Anyone help at all?

    Thanks in advance!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,471

    Re: CHALLENGE - Extract data from a table with multiple conditions....

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Registered User
    Join Date
    10-16-2014
    Location
    England
    MS-Off Ver
    Excel 2002
    Posts
    2

    Re: CHALLENGE - Extract data from a table with multiple conditions....

    Hello,

    I have added the sample table to the attached.

    Tried to add my sample formulas and give a breakdown of what is required. i.e. the yellow cell at the top denotes the correct value which should be pulled through from the bottom table.

    I always want the table to pull through the TOTAL figure so this needs to be looked up as a third parameter.

    Thanks
    Attached Files Attached Files
    Last edited by horkstar; 10-16-2014 at 11:35 AM. Reason: Grammar

+ 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] Need to return data from a table based on multiple conditions
    By skayem in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-27-2014, 11:12 AM
  2. [SOLVED] Extract Data from one to another using conditions
    By missy22 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-26-2014, 07:36 AM
  3. Extract Data based on conditions on multiple columns
    By checkoncomp in forum Excel General
    Replies: 6
    Last Post: 07-03-2013, 01:54 PM
  4. Replies: 2
    Last Post: 06-01-2012, 09:24 AM
  5. Replies: 9
    Last Post: 07-17-2010, 05:28 PM

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