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?