Z Zack Aug 22, 2008 #1 I am trying to remove duplicate records but the Advanced Filter option is grayed out. What is the trick to have that option viable?
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 Aug 22, 2008 #2 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...
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...
