Identify records where sales order contains multiple items

Here's a better explanation:

I have a recordset that looks like this:

Sales Order	Item ID	Accessory
ABC100	302	1A
ABC100	443	2A
EFG200	105	1A
EFG200	105	1B
HIJ300	790	3A

I need to identify the sales orders containing multiple (unique) items. Any ideas for a formula that could help me mark each of those records? Items will often appear more than once in this excel file because an item can be associated with multiple accessories. I would be looking for something like this:

Sales Order	Item ID	Accessory	Multiple?
ABC100	302	1A	Yes
ABC100	443	2A	Yes
EFG200	105	1A	No
EFG200	105	1B	No
HIJ300	790	3A	No

Thank you for your help.

Hi HK106,

I'd do this problem with two helper columns. See the attached. The Counter Column > 1 are all double entered items.

Ace_XL,

Thank you for the suggestion, and I appreciate that somewhat is making an effort to help me, but your formula erroneously assigns "No" to a record when an item on a sales order has multiple accessories.

Allow me to expand my example:

Sales Order	Item ID	Accessory
ABC100	302	1A
ABC100	443	2A
EFG200	105	1A
EFG200	105	1B
EFG200	523	1A
HIJ300	790	3A

What I'd like to see:

Sales Order	Item ID	Accessory	Multiple?
ABC100	302	1A	Yes
ABC100	443	2A	Yes
EFG200	105	1A	Yes
EFG200	105	1B	Yes
EFG200	523	1A	Yes
HIJ300	790	3A	No

So EFG200 would be "Yes" because it is associated with multiple items. The number of accessories on an item doesn't matter. I just want to identify the sales orders that are associated with multiple items.