Hello,
I need to find the correct formula to find a specific value such and sum all the sizes without any duplicates. Please see below for the table example.
Basically, what I need to achieve is a formula to find BANANA and give a total size number of 3 because banana has small medium and large (3 different sizes), same goes for APPLE with a returning value of 3 because there 3 different sizes for apple too. If I added values of ORANGE with only Small and Medium then I need the formula to return the value of 2 because there are only 2 different sizes.
Thank you!
I need to find the correct formula to find a specific value such and sum all the sizes without any duplicates. Please see below for the table example.
Basically, what I need to achieve is a formula to find BANANA and give a total size number of 3 because banana has small medium and large (3 different sizes), same goes for APPLE with a returning value of 3 because there 3 different sizes for apple too. If I added values of ORANGE with only Small and Medium then I need the formula to return the value of 2 because there are only 2 different sizes.
Thank you!