Advanced filter to show unique records

[ResulG]

Hi All,

I am trying to apply a filter on the unique records only but cannot overcome this problem.

What I have is data in columns A to P. I want to apply a filter on column K (which have repetitive data) but because columns E and F have unique referencing, unique record filtering does not work.

Is there a way of overcoming this issue?
I have attached the file.

ResulG

[Carim]

Hi,

You have to be careful about Unique records definition ...

i.e. if you are after the unique of a given column (say column K),
you should only include this column in your range to be filtered ...

HTH
Carim

[ResulG]

So simple!

Thanks Carim

[Carim]

You are welcome ...

Thanks for the feedback

Carim