I'll try to keep this as short and concise as possible.
I'd like to create a list of unique values extracted from another raw-data list.
See attached sheet for reference. Here's a picture of it:
2019-03-13 10_01_14-Unique List on multiple criteria.xlsx - Saved.png
1. I'd like to remove duplicates that have both values from col-C and col-E repeated in rows. (No duplicates of Supplier+Parts).
2. Optional Bonus task (Yellow cells): I'd like to add col-G and col-H that looks up Supplier&Part and gives the value of col-B based on col-A as a criteria. Looking at the "What I want" table makes more sense than words IMO.
I tried this with COUNTIFS formula, and VLOOKUP. I didn't manage that with the 2+1 criteria in this case.
Please ask if anything is unclear.
I feel I may not explain this sufficiently in text.