duplicate records

Z

Zack

I am trying to remove duplicate records but the Advanced Filter option is
grayed out. What is the trick to have that option viable?
 
S

Sheeloo

You must be in the edit mode. Click anywhere on the worksheet to get out of
edit mode.

Let me know if this solves your problem.

There are other ways to find duplicates...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Advanced Filter Grayed Out??? 3
Unique Values, not Unique Records 1
Advanced Filter 2
KEEP duplicate records 3
Duplicate entries 2
filtering out rows with duplicate information 1
How do I remove or filter out duplicate records in a sheet? 4
Bug in Advanced filter 1

Top