Advanced Filter multiple criteria

[LTSSB]

I have a data sheet similar to this. I would like to know what I need to do to create formulas/functions that allow this to happen while running an advanced filter.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Rank(5 Star Rating System[/TD]
[TD]Name(Multiple duplicate names)[/TD]
[TD]Tier(Typical letter grade scale)[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Name1
[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Name2[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Name1[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Name1[/TD]
[TD]C[/TD]
[/TR]
</tbody>[/TABLE]

I have 3 sheets as follows, "Data",FilterData", "Lists"
Data has data obviously

Filter data has input area(3 data validation drop boxes here), *criteria area(missing formula to make it true to the conditions)*, and extract area(well extract not yet set up due to missing formulas)

Lists has the 3 criteria listed and dynamically named ranges

I have tried looking this up and none of the examples deal with mostly text strings but numbers instead. Am I able to assign an integer to a text string or what is the best way to go about it?

I was able to retain some of what I saw in the manys videos/ tutorials as far as getting to this point( and even after, meaning I am able to set up recorded macro) I just cant seem to grasp what I need to do for the worksheet code.

Any help would be greatly appreciated.
Thanks in advance,
LTSSB

 

[LTSSB]

I'm sorry, I forgot to explain what my main/overall goal was. I would like to make a userform that searches "Data" using the criteria to extract the full range of each row item so that I can compare said items. I am also planning on adding a "buffers" input to adjust row cell values accordingly. (This part I have figured out and already have implemented) just waiting to get the proper way to extract and display.

 

[LTSSB]

https://www.excelforum.com/excel-pr...73-help-with-advanced-filter.html#post4866567

CROSS POSTED DUE TO LACK OF RESPONSE

 

[LTSSB]

This thread can be marked solved as the cross posting link solved the problem