CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
ThousandSteps
ThousandSteps

Reputation: 85

Count in how many categories an item appears - Google Sheets

Is it possible to achieve the result from Column C using Google Sheets formula?

enter image description here

I was able to count using Query and Unique, but the result is grouped by item. I need the result in a separate column for every item in the list.

enter image description here

Upvotes: 0

Views: 144

Answers (1)

The God of Biscuits
The God of Biscuits

Reputation: 3207

Given your example, use the following in C2:

=map(B2:B9,lambda(each,countuniqueifs(A2:A9,B2:B9,each)))

Upvotes: 1

Related Questions