advanced filter
 

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

advanced filter
 

Hi

you might have more success if you changed your list range to P2:P7065

Cheers
JulieD

"Carbide Guy" <Carbide wrote in message
...
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

advanced filter
 

List Range should be

List Range - $P$1:$P$7065

if you want uniques based on the values in column P.

--
Regards,
Tom Ogilvy


"Carbide Guy" <Carbide wrote in message
...
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