Remove Duplicates
Is there a formula to remove duplicates in a column?
|
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? |
Remove Duplicates
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? |
All times are GMT +1. The time now is 06:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com