Excel 2013 order a list and remove duplicates

Ordering a list and removing duplicates is a common and useful operation, when working with data lists : email addresses, invoice numbers, values, …

One solution to quickly process large sets of data can be to use Notepad++.

Another possibility is using Excel 2013 from Microsoft Office 2013 suite.

 

 

 

Starting with your set of data, select the column(s) for which you want to remove duplicates.

 

 

 

 

Then, from the DATA menu, select the “Remove duplicate” options.

 

In the popup, select if your data has header or not (meaning, a first line that will not be considered in the operation), and the columns you want to consider, and click Ok.

You should get a confirmation with the amount of duplicates deleted and unique values remaining.

Finally, you might want to sort the data. Keeping your selection, in the same DATA menu, select ascending or descending sort, and voilà !

Related articles across the web

• Thousands of UK Government emails revealed in AdultFriendFinder hack
• 12 Ways to Protect Your LinkedIn Account
• Tech Skills All MBA Students Should Know
• Largest hack of 2016? 412 million AdultFriendFinder accounts exposed
• More Than 400 Million Users Of Numerous Adult Websites Are On The Verge Of Being Exposed After Hack
• The Most Loved, Fun, Relevant, Engaging, Social, and Helpful Brands