Dealing with Duplicates in Microsoft Excel 2010

If you have large amount of data in Microsoft Excel 2010, you wouldn’t want to manually check the data if it is completely right or not. You would want to rely on the formulas or the functions that exist in the application to make things easier for you and to save your precious time. This is one such feature that allows users to remove the duplicates from the data that’s exists on a page or a worksheet as they call it.

Now imagine this situation, you receive huge data from various sources and you copy-paste the whole data in a worksheet. What if you copy certain amount of data twice? What if you copy a row of information twice? Would you check it manually? Would you go through every row if the total number of rows is over a hundred? In such situation you can simply remove the duplicates from the data using this feature.

This is a simple process that can be completed in just a few steps. To know more about this, read the complete story here.

Image by barbourians