I have a large dataset in an Excel sheet where:
- column A: quote number
- column B: opportunity number
- column C: sales order number.
One quote number will have multiple opportunity numbers. A sales order number will be generated if an opportunity is closed. What I need is a formula that can flag a quote as "closed" status when all opportunities related to that quote have a sales order number. E.g.,
Column A | Column B | Column C
---------+----------+----------
123 | 247689 | K123
123 | 678889 | K456
578 | 555678 | K889
578 | 678999 |
For the above example quote 123 should be flagged as "closed".