We can remove duplicate entries in a list using MS-Excel.
Click Data->Filter->Advanced Filter in the Excel sheet.
Check the 'Unique records only' checkbox in Advanced filter Dialog box, to remove the duplicate entries in the list.
More Articles...
skip to main |
skip to sidebar
Blog about Web development, SEO, Online business, Software Testing and Tech News.
About Me
Blog Archive
-
▼
2009
(257)
-
▼
February
(13)
- PHP - Enable cURL in Windows.
- Excel - Removing duplicate values
- Javascript- Accessing DOM before completion of pag...
- C# - Handling symbols in webbrowser control
- Cross browser web development.
- Online Bookmark
- MySql version issue.
- MySQL - Importing Large sql file
- Bookmarklet
- Our vision and Values
- Google Analytics
- Offline Crawling - Resolved the issue with webbrow...
- Issue with GD Library
-
▼
February
(13)
Emerging Tech eBookeBook useful for knowing about Emerging Technologies and earning money with them.Motivational QuotesGet Quotes for Motivating and Inspiring everyone. You can get both text Quotes and Image Quotes. |
1 comment:
By using the advance filter we can easily remove the duplicate contents. Otherwise use a dedupe software for excel. It will find and remove the duplicate values.
Post a Comment