Forum Discussion
Count unique values in range
Hi I want to work out how many unique ingredients are in the Vegan restaurant, which are not in the Main Restaurant. For instance here in recipe 1 - there is 1 unique ingredient (tofu - as 'avocado...
How about
=SUMPRODUCT((C$2:C$4<>"")*ISERROR(MATCH(C$2:C$4,C$5:C$7,0)))in C10. Fill to the right to D10.