J
Joe
Is there a formula to remove duplicates in a column?
J
Joel
The best method is to use
Data - Filter - Advance Filter and check the unique box.
Data - Filter - Advance Filter and check the unique box.
A
Ashish Mathur
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
50;
2. In cell E2, enter =if(countif(D250,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
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
50;2. In cell E2, enter =if(countif(D2
50,D2)>1,"A",1) and copy down till E503. 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