# Pull data from one sheet to another based on multiple criteria

1. ## 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.

2. ## 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:
`Please Login or Register  to view this content.`

_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you

Alvin

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

Im giving you an example formula with intersection layouts

Azumi

4. ## 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.

5. ## 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

Alvin

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

#### 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