Use Microsoft Excel 2010 Formulas to Find Duplicate Rows

Have you lately started using the Microsoft Excel 2010 application? If you are yet to check out the handy formulas that you can apply here, read through this article to learn the steps using which you can easily find and remove duplicate rows. This can be particularly useful to you when you are compiling huge data sheets from multiple sources or have multiple users updating the same sheet. Toward the end of the compilation, when you will be giving the sheet a final touch, do remember to use this formula to make sure that your report doesn’t contain any duplicate entries. Use this application to work like a pro…

The easy steps that you can follow to complete the task are:

1. To find duplicate rows, first collate the data from columns into a new column.
2. Select a cell in a new column and type ‘=reference to the first cell of the row you want to collate & ‘any attribute you want to add’ & reference to the last cell of the row you want to collate’
3. Press ‘Enter’ on your keyboard and click on the bottom right corner of the cell and drag it all the way down to the last cell.
4. Select the cell where you want to display the result.
5. Type ‘=COUNTIF (the absolute reference to the first cell shown by the $ sign : reference to the first cell, reference to the first cell again)’
6. Press ‘Enter’ on your keyboard and click on the bottom right corner of the cell and drag it all the way down to the last cell. 

Footnotes:

Keep these steps handy to make sure that just before you send out that important report to your boss or business associates, you definitely identify and remove the duplicate rows from it. It isn’t easy to make an impression, therefore leave no stone unturned to utilize the opportunity you get! Use Microsoft Excel 2010 to help you out with this…

For now, here’s a short solution video that you can check out. Click below to watch it now:

http://www.youtube.com/watch?v=thts0-vlrjU