I have a list of products purchased by various customers.
Certain Products are defined as MTO - Made to Order.
I need to count all unique entries for all products where they are MTO ie
Column A Column B
Cars MTO
Bikes Stock
Cars MTO
Shoes MTO
Horses Stock
Cats MTO
Dogs MTO
Cats MTO
Therefore unique MTO products are
3
Is there a simple formula for this ?
Certain Products are defined as MTO - Made to Order.
I need to count all unique entries for all products where they are MTO ie
Column A Column B
Cars MTO
Bikes Stock
Cars MTO
Shoes MTO
Horses Stock
Cats MTO
Dogs MTO
Cats MTO
Therefore unique MTO products are
3
Is there a simple formula for this ?