I have used this before on the same spreadsheet and sometime it works
sometimes not. I have data from A1:A7065 Row 1 being column heading's. I am
trying to find unique records in P2:P7065, this field is made up from other
data by =J389&", "&K389&", "&L389&" "&M389&" "&N389&" "&O389. I have tried
selecting the entire sheet or just P2:P7065. I am stumped as to why this
works sometimes and not all the time.
Advanced Filter
Action - Filter the list in place
List Range - $A$1:$V$7065
Unique Records is checked