EssayproSolutions

(Solved) : Excel Formula Use Vendor Type Field Find Item Different Vendors One Vendor Vendor Order Q34240615 . . .

What excel formula can I use in the Vendor-Type field to findout if an Item No. has different Vendors or only one Vendor?

Vendor No.Order No.Item No.Vendor Type2A01116489=IF(FREQUENCY($A$2:$A$99=$A2,$C$2:$C$99=$C2),”Unique”,”Multiple”)6A01255319The above formula is wrong but I am thinking If statement6A012343126A02045319

Expert Answer

Answer to Excel Formula Use Vendor Type Field Find Item Different Vendors One Vendor Vendor Order Q34240615 . . .