Counting mixed orders with different products

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

Hi,

appreciate your fast reply. for this task, i can't remove duplicates since there are none.
E.g. Order 1111 contains product A and product B, i.e. it is a mixed order. Now I want to tell excel that this is a mixed one and in the second step that product A is from department 1 and product B from the other department.

thx.

Markus