Example sheet attached.
I have a pivot table that displays widgets on the left column and profit margin as a value. I need to set up a drop down list on another sheet that only gives me ITEMS whose value is lower than x.
This is way over my head, but the example spells out what I am trying to do.
Bookmarks