Hello there,
I have a table with 3 columns. The 1st column simply concatenates the next two columns, so it can be ignored if it doesn't help.
I want to obtain the list of unique values in the 3rd column (except one particular phrase), if the 2nd column matches a specific cell reference.
An alphabetical output is preferred, but not required.
Please see the attached file for a clearer overview. Any help is greatly appreciated.
I'm somewhat experienced with Excel, but I simply cannot get this working. This is my first post on Excelforum. Thank you.
Bookmarks