Hi this is my first post. I have recently landed a job where i deal with excel a lot. I am preparing a report and i am unable to write a formula for counting some unique values.
here is my dilemma.
In colunm 'A' i have some repeating values and in column 'B' I have the 'type' for Column A's values. I want to write a formula where it checks the 'type' first and them count the number of unique values in colums 'A'
Coumn A Column B
Pr1 Soap
Pr1 Soap
Pr1 Soap
Pr2 Food
Pr2 Food
Pr3 Cloth
Pr4 Cloth
Pr5 food
so the formula should count the unique number of products in column A by checking its type in column B when I prepare a table of the number of products based on type.
this should be my result
Soap Food Cloth
1 2 2
Bookmarks