Hello,
I have the following data structure:
Cell | Data "Product"
A1 | bread
A2 | Milk, bread
A3 | Milk, bread, cheese
A4 | cheese
A5 | bread, cheese

I want to be able to make a graph that shows
bread 4 occurrences
cheese 3 occurrences
Milk 2 occurrences

My problem is I have over a thousand products and only want the top 10 occurrences.
Is my only solution is to find the most common product, the create a second table for the graph?
The top 10 may change so I didn't want a manual step each reporting period.

Thanks for taking a look!!