I'm attempting to count repeating numbers in a list but only count them once for each occurrence.
Here's an example.
This is the source.
Control # Category Description 123456 12 unique text 123456 12 unique text 123456 12 unique text 654321 14 unique text 654321 14 unique text 654321 14 unique text 456789 16 unique text 456789 16 unique text 456789 16 unique text 789123 14 unique text 789123 14 unique text 789123 14 unique text
I need to count the number of unique category instances for each control number. The categories may occur several times but under different control numbers. The result should look like the table below but I'm stumped on how to achieve it with formulas.
Categories Count 12 1 13 0 14 2 15 0 16 1
Bookmarks