Removing filtered data

[bon]

I have a list of over 3000 items, after which I filter to unique recored only I end up with 51. I would like that to be my new list. The filter displays the unique data but retains all 3000 records, I would like to eliminate the others. Thanks in advance.

 

[just_jon]

While the data is filtered, copy it to another location -- should just copy the visible cells, I think.

 

[bon]

While the data is filtered, copy it to another location -- should just copy the visible cells, I think.

If I copy it takes it 3000 rows (hides tthem but still takes them)

 

[rs2k]

Can you not use Data|Filter|Advanced Filter and check the unique records only and choose the copy to another location?

Or have I mis-interpreted your question (I'm quite good at that)
Colin.

 

[bon]

Yes that works, I am the one doing the misinterpretation.
Thanks much to all!!!!