Avatar of gh_user
Flag for Australia

asked on 

Excel Table - Filtering on Unique Values in specific column

I have a table with 5 columns (A to E).
I wish to filter based on criteria of unique values in Column D (which is by the way a concatenation of Columns A & B)
Im trying to use Advanced Filter with little success.
I assume the List range is the whole table, and I select the box unique records only.  But what do I put in criteria range?
Or should I be doing it differently?
Microsoft Excel

Avatar of undefined
Last Comment

8/22/2022 - Mon