Hi community,

I am a new member with probably not a new problem. :D

I'd like to count customer orders and distinguish them between mixed and single orders. For example, I created this table below where I have 4 different orders (total amount of orders). These orders can be distinguished between mixed and single orders. In this case I have 2 single (i.e. order no. 2222 and 3333) and 2 mixed orders (i.e. 1111 and 4444). How can I let excel calculate these?

order product mixed single
1111 A
1111 B
2222 A
3333 A
4444 A
4444 B
4444 C
4444 D


Thanks in advance.

best regards,

Markus