Remove duplicate records using Excel

To solve this problem, we need to remove repeated records. I am too lazy to write C # code to do this. I learned this trick from my colleague Derek.

 

Use an example.

 

 

 

Select two columns. The result is as follows.

 

Select column A only. The result is as follows:

 

Use it flexibly based on actual needs to improve work efficiency.

 

References

======================

Remove duplicate data records in Excel Part 1

Http://spreadsheets.about.com/od/datamanagementinexcel/ss/2011-05-29-excel-2010-remove-duplicates-tutorial.htm