+ Reply to Thread
Results 1 to 9 of 9

I need to pull specific data based on multiple criteria

  1. #1
    Registered User
    Join Date
    11-25-2020
    Location
    Las Vegas
    MS-Off Ver
    365
    Posts
    4

    I need to pull specific data based on multiple criteria

    I have raw data that lists employees for each tender type. I would like to consolidate the information for just some of the tender types, such as cash and service charges, to make a variance tracking sheet. In the attached sample, my data is on the left, in yellow, and where I would like to see it is on the right. I've highlighted in blue the columns that need to pull data from the left. Any help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: I need to pull specific data based on multiple criteria

    If you have 365 you can use the news functions UNIQUE and XLOOKUP

    In K2:
    =IFERROR(XLOOKUP(L2,C:C,B:B),"")

    In L2:
    =UNIQUE(C2:C2000)

  3. #3
    Registered User
    Join Date
    11-25-2020
    Location
    Las Vegas
    MS-Off Ver
    365
    Posts
    4

    Re: I need to pull specific data based on multiple criteria

    Those columns are not dependant on the data on the left. That list will always remain unchanged. I need to pull cash, fast cash, and service charges based on a match between either columns L and C, or columns K and B

  4. #4
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: I need to pull specific data based on multiple criteria

    in which column does this appear:
    cash, fast cash, and service charges ?

  5. #5
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: I need to pull specific data based on multiple criteria

    you want to sum up all the type of charges per employee?

  6. #6
    Registered User
    Join Date
    11-25-2020
    Location
    Las Vegas
    MS-Off Ver
    365
    Posts
    4

    Re: I need to pull specific data based on multiple criteria

    I'm trying to pull the data horizontally, so there is only one row for each employee that shows cash, fast cash, and tips. I'll then throw in a formula to tell me how much the employee should have turned in, but I need each item listed separately for reporting purposes. The originating data is all listed in column F

  7. #7
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: I need to pull specific data based on multiple criteria

    OK, please see the attached:

    N2-O36 (assuming the amounts are in G:
    =SUMIFS($G$2:$G$36,$B$2:$B$36,$K2,$F$2:$F$36,N$1)

    P2 (assuming the service charge amount is in H:
    =SUMIFS($H$2:$H$36,$B$2:$B$36,$K2,$F$2:$F$36,P$1)
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    11-25-2020
    Location
    Las Vegas
    MS-Off Ver
    365
    Posts
    4

    Re: I need to pull specific data based on multiple criteria

    I swear, I tried sumifs and couldn't get it to work. I think you just saved my life. Thank you!!!

  9. #9
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: I need to pull specific data based on multiple criteria

    I think I know why it didnt work for you - you need to make sure that the titles are exactly the same as the names on your column....otherwise there will no matches found.

    You're welcome.

+ 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] Data Pull from Multiple Worksheets based on Criteria!!!
    By Rajeshkumar R in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-26-2017, 07:10 AM
  2. Compare data on two sheets and pull multiple results based on criteria
    By Mandross in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-20-2017, 06:58 PM
  3. [SOLVED] Pull data from a table based on multiple criteria - old formula trying to use AND
    By tweaver in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-12-2016, 04:37 PM
  4. [SOLVED] Pull data from one sheet to another based on multiple criteria
    By thestalkycop in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-15-2014, 01:38 AM
  5. [SOLVED] Pull data from multiple cells into one cell based on criteria?
    By chaddug in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-23-2012, 09:54 AM
  6. Pull random data based on specific criteria
    By Jrsmith1 in forum Excel General
    Replies: 1
    Last Post: 09-17-2012, 11:09 PM

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