+ Reply to Thread
Results 1 to 5 of 5

Pull data from one sheet to another based on multiple criteria

  1. #1
    Registered User
    Join Date
    01-13-2014
    Location
    Leeds
    MS-Off Ver
    Excel 2010
    Posts
    2

    Pull data from one sheet to another based on multiple criteria

    Hi all

    This has been making my brain explode for several days now, so thanks in advance for even reading this.

    I have a skills matrix which gives everyone a ranking of 0-4 for their skillset in certain applications. It also shows whether each user is online. I've been tasked with making a separate sheet that only shows the experts (highest scorers) in each area that are currently online.

    This is a very simple version of my spreadsheet.

    DummySkillsMatrix.xlsx

    I need it to see that both Lucy and Sarah score 4 in Word, and not throw out an error because there's more than one expert in that category - if we could pull out both names, that would be awesome.

    Also, some applications are new, so nobody's an expert yet, with everyone scoring 1 or 2, so I need it to search for the maximum score in that column, rather than specifically looking for 4. Also, in the case where we're all new to software, I don't really want it dragging out all 40 names of the team out, so limiting it to 3 would be good.

    Any assistance would be much appreciated - thanks.
    Last edited by thestalkycop; 01-14-2014 at 02:22 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    12-25-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    506

    Re: Pull data from one sheet to another based on multiple criteria

    Welcome to the forum.
    Assume that in Expert sheet column B to column D will show names with top scores for respective applications, try array formula (ctrl+shift+enter) below in B1 and copy across D4

    Formula: copy to clipboard
    Please Login or Register  to view this content.




    _______________________________________________________________________________________________________________________________
    1. Click on the * Add Reputation if you think someone helped you
    2. Mark your thread as SOLVED when question is resolved

    Alvin

  3. #3
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    2,244

    Re: Pull data from one sheet to another based on multiple criteria

    Im giving you an example formula with intersection layouts

    Azumi
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-13-2014
    Location
    Leeds
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Pull data from one sheet to another based on multiple criteria

    Thank you both so much for your help.

    One tiny thing, my spreadsheet also has "N/A" as an option (some workers do not work with certain applications) and now it's pulling through "N/A" as the top value. Is there away around this? I ended up using Alvin's formula.

    Many thanks.

    Edit: Never mind - I don't know what I did to break it, nor fix it, but this error is no longer happening. Thanks both.
    Last edited by thestalkycop; 01-14-2014 at 02:21 PM.

  5. #5
    Valued Forum Contributor
    Join Date
    12-25-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    506

    Re: Pull data from one sheet to another based on multiple criteria

    Thank you for the feedback, you're most welcome



    _______________________________________________________________________________________________________________________________
    1. Click on the * Add Reputation if you think someone helped you
    2. Mark your thread as SOLVED when question is resolved

    Alvin

+ 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. Pull ranked data from another sheet based on one cells criteria
    By murphyjeff08 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-19-2013, 11:51 AM
  2. Replies: 5
    Last Post: 07-23-2013, 01:17 PM
  3. Pull data from one sheet to another based on criteria
    By lowrymike in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-12-2013, 12:53 PM
  4. Pull data from one sheet to another using multiple criteria
    By Farhaad Saleh in forum Excel General
    Replies: 5
    Last Post: 07-22-2011, 10:32 AM
  5. [SOLVED] Pull data from another sheet based on certain criteria
    By steve_sr2 in forum Excel General
    Replies: 1
    Last Post: 02-23-2006, 06:15 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