Hello everyone,
I'm quite the novice when it comes to macros/formulas, so I need your help for this one.
I created a benchmark of figures on product sales of a shop: (average price per product, average # of sales per product).
I have a huge list of products with their price and how many times they have been sold in our shop.
Now i'd like to have another list show up in a seperate tab with ONLY the products (+data on price and sales) that have ONE OF their values above or equal to the benchmark.
i.e.
Benchmark:
Avg. price: €10
Avg. sales per product: 4
Products
product, price, sales
a €4 2
b €11 6
c €3 14
So here I'd like to have a list come up that shows (and thus filters out product a) :
b €11 6
c €3 14
I hope you can help me... Thank you in advance!
Bookmarks