Advanced filter complex combination search

[gerardgerard]

Hello All,

I am confused on how to get an advanced search to work on a multiple criteria in which I want all inputs to be linked to one another and to do a combination search. To better explain, I will provide visuals>

this is my basic criteria:
starting column is A image

this is what I want from it and I honestly thought that the excel advanced filter worked this way:
[FYI:the values I want it to paste are the scores in some random cell]
starting column is K image

This is the dataset (all made up):
largest image

please let me know if something can be created to accomplish this

thanks!

[humdingaling]

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 then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).

[Dineth]

what is your excel version? 2010?
go to data tab and click filter. or just make a table with your data.
click the dropdown arrow at filter button in each column you want to filter and it will filter your database as the way you need it.