View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Remove Duplicates

The best method is to use

Data - Filter - Advance Filter and check the unique box.

"Joe" wrote:

Is there a formula to remove duplicates in a column?