Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What excel formula can I use in the Vendor-Type field to find out if an Item No. has different Vendors or only one Vendor? Vendor
What excel formula can I use in the Vendor-Type field to find out if an Item No. has different Vendors or only one Vendor?
| Vendor No. | Order No. | Item No. | Vendor Type |
| 2 | A0111 | 6489 | =IF(FREQUENCY($A$2:$A$99=$A2,$C$2:$C$99=$C2),"Unique","Multiple") |
| 6 | A0125 | 5319 | The above formula is wrong but I am thinking If statement |
| 6 | A0123 | 4312 | |
| 6 | A0204 | 5319 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
