<p>What excel formula can I use in the Vendor-Type field to findout if an Item No. has different Vendors or only one Vendor?</p><strong>Vendor No.</strong><strong>Order No.</strong><strong>Item No.</strong><strong>Vendor Type</strong>2A01116489=IF(FREQUENCY($A$2:$A$99=$A2,$C$2:$C$99=$C2),"Unique","Multiple")6A01255319The above formula is