Extract unique values with conditions to a list

[moranda]

Hi,

I'm using XL2010 and Windows 7.
I need to extract to a dynamic list from an employees database all the employees I.D's that are "Active" and belong to a certain region.
Let's say I have a long list with the following columns:
I.D.| Employee Name | Status| Region
and below some employees are "Active" and some are not, some belong to region "NJ" and some to "NY"

I want to create a table that will list only the Active employees from NJ below "NJ"column and the active employees from NY below the column "NY"

Would really appreciate any help!,

Thank you

 

[SteveO59L]

Try a filter