Hello,
I have a file that is pulling in catalog information from another excel file. I am interested in creating a formula that pulls in only the unique results based upon multiple criteria.
For example
Line 1 A X 5
Linie 2 A X 5
Line 3 A X 6
Line 4 A X 6
How do I look up the criteria for "A" and "X" and only return the 5 and the 6 as unique results based on that combination of criteria?
Many Thanks!
Bookmarks