I am asking for a solution to this scenario in Excel.
I want to get a count of sets of unique values in one column that are associated to values in another column.
Example: A B C In column A there are 4 unique values in the data set. Duplicates that extend from
1 a 3 data links as unavoidable in this scenario. I would like a formula in Excel that
1 a 3 will show the amount of sets associated with the values in column B. The results
2 a 3 would match the data in column C where the formulas would be placed. 3 different
2 a 3 sets are associated with value “a” in column B. And 1 set is associated with value
3 a 3 “b” in column b.
4 b 1
4 b 1