Is there a formula to remove duplicates in a column?

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?

Hi,

In Excel 2007, you can this with the built in "Remove Duplicates" feature.
In Excel 2003, you will have to make use of a spare column.

1. Suppose the data is arranged in range D2:D50;
2. In cell E2, enter =if(countif(D2:D50,D2)1,"A",1) and copy down till E50
3. Now highlight E2:E50 and hit F5. Click on Special
4. Now under the Formulas radio button, uncheck all boxes except "Text"
5. Now Edit Row delete

HTH

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Joe" wrote in message
...
Is there a formula to remove duplicates in a column?