Hi,

I am working on a project where I have a list of items that I would like to filter based on statistics of those item. Once filtered I would like to utilize a drop down on another sheet that would display just the filtered items from the original list. Additionally, if the list of items is not filtered I would like the drop down to list all items.

I have attached a test file of what I am working on.

Thanks in advance for your help guys.


Sample.xlsx