Monday, November 30, 2009

Excel trick - Pasting unique records from a selection

I have some values in the excel sheet in a column. I want to find the distinct values in that column. Most of us (at least until now I was doing this) first sort the values, then delete the rows while retaining the distinct values. Here is a functionality that excel offers us.

Click on the "Advanced" in the "Sort & Filter" functionality group in the Data Menu item.

In the dialog box that follows, select the range of cells (which has duplicate values), select the pasting region and check the check box "Paste Unique records only".


2 comments:

parvina said...

I love your article. You can visit my website.
free download clean master pro terbaru

Danny Danials said...

I have been using this app PickCrafter Mod Apk : and downloaded and playing it regularly.