Excel: Identifying common groups of properties for IDs
Solution 1:
You may use the formulas to count the IDs for different groups.
First I suggest you use the formula =TEXTJOIN(",",TRUE,IF($A$2:$A$13=D2,B$2:B$13,""))
to handle data as following. Then one line for one ID.
Such as for [apple,Orange], please use the formula =COUNTIF(E2:E5,"*apple*orange*")
to get count.
Such as for [pear], you may use the formula =COUNTIF(E2:E5,"*pear*")
.
You may count the group of differen flavours as you want. After get the counts, you may use pivot table or formulas to get the quantity order from high to low.