Removing duplicates in an excel column

jhalloran

New Member
Joined
Sep 27, 2006
Messages
1
I have seen many posts on what to do...my problem is I cannot figure out how to select ADVANCE FILTER under DATA/FILTER...mine will not highlight so it can be selected??? What do I need to set so that is available to use?

Thanks
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Watch MrExcel Video

Forum statistics

Threads
1,113,920
Messages
5,545,029
Members
410,647
Latest member
bernardazar
Top