Pulling list of Unique Names from Refresh-able Table between Date Range (Or Month Number)

[SirGruffles]

Hello! Thanks for any help in advance:

I'm attempting to create a "dynamic invoice" of sorts, with names being pulled from a "refresh-able" table.
By that term, I mean an excel table that (I'm assuming) is pulling from an SQL query and just needs the "refresh all" button on the Data tab to be hit.

Here is an example of my table, with the headers in col A row 1, continuing down to K row 5 at the bottom:

area	Area_name	EmpID	Emp_Name	Operation	Hru_Used	Lab_Type	Prdate	Month	WorkCell	DefaultArea
27​	Shipping	1002​	Patrick Pentagon	Shipping Amazon Orders	8​	Direct	5/1/2020 0:00​	5		Doesn't Matter
15​	Shipping	1001​	Spongebob Circlepants	Shipping Amazon Orders	8​	Direct	5/5/2020 0:00​	5		Doesn't Matter
12​	Repairs	1003​	Eugene Lobster	Managing	8​	Direct	4/30/2020 0:00​	4		Doesn't Matter
15​	Shipping	1001​	Spongebob Circlepants	Shipping Amazon Orders	8​	Direct	5/6/2020 0:00​	5		Doesn't Matter

The goal is to create a formula that will pull all of the *unique* names from a list that meet the following criteria:
1) Must be under the "Shipping" Area_Name
2) Must have a Prdate between 05/01/2020 - 05/31/2020 OR Must have a Month value = 5,
3) Can't have repeat names, IE the *unique* part

The reason for this need to craft an "automated" datasheet for some of my operations leaders in order to verify billing hours within a month.
I also want to make it as.... accessible as possible for the less....tech-savvy. Being able to tell them to simply "Refresh All" would be a great benefit.

At the end of this basic example, the results should show:
Patrick Pentagon
Spongebob Circlepants

Please let me know if I'm missing any important points.

Thanks for your help!

 

[DanteAmor]

Try this array formula.
(I hid some columns)

Dante Amor
	A	B		D					I			L
1	area	Area_name		Emp_Name					Month			Result
2	27	Shipping		Patrick Pentagon					5			Patrick Pentagon
3	15	Shipping		Spongebob Circlepants					5			Spongebob Circlepants
4	12	Repairs		Eugene Lobster					4
5	15	Shipping		Spongebob Circlepants					5
Hoja3

Cell Formulas
Range	Formula
L2:L5	L2	=IFERROR(INDEX($D$2:$D$6,MATCH(0,IF(($B$2:$B$6="Shipping")*($I$2:$I$6=5),COUNTIF(L$1:L1,$D$2:$D$6),""),0)),"")
Press CTRL+SHIFT+ENTER to enter array formulas surrounded with curly braces.

 

[SirGruffles]

That did it! Thank you very much!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.