adspace


How do I find duplicates in multiple columns?

Answer Posted / Pradeep Kumar Gupta

To find duplicates across multiple columns in Microsoft Excel, first select the entire dataset and then go to the Data tab. Click on 'Remove Duplicates' in the Data Tools group. If you only want to remove duplicates based on specific columns, select those columns before using the 'Remove Duplicates' option.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is latest version of excel?

722


How much is excel for ipad?

714


Image result for how do I compare two columns in excel

668


What is left formula in excel?

684


What is wrap text in excel?

721


Why can't I see the tabs on my excel spreadsheet?

724