excelbytes
Active Member
- Joined
- Dec 11, 2014
- Messages
- 251
- Office Version
- 365
- Platform
- Windows
On the attached is a list of orders and line items. Based on certain criteria, column C indicates whether to include it in the list of Orders in column D or not. What would be the formula to generate a unique list of orders in column D that exclude any order that has a "No" associated with it in column C?