What’s left are the unique Weight values in chronological order. Remove column C by right-clicking the header, and click Delete from the popup menu. In the Delete dialog box, select Entire row and then click OK. Right click on one of the TRUE cells, and from the popup box select Delete… Type TRUE in the Find What box, and click Find All.Ĭlick inside the bottom window of the Find and Replace dialog box, and use Ctrl+A to select all the values found. Select all formulas by making C2 the active cell, and use the keyboard shortcut Ctrl+ Shift+Down arrow.įind all the TRUE values by using the keyboard shortcut Ctrl+F. In cell C2 add the formula: = B2=B1, which will be FALSE if C2 is unique, and TRUE if it’s a duplicate value to the cell above it.Ĭopy the formula down by double clicking the fill handle. The following procedure worked well for this data set. Earlier versions of Excel have to rely on doing this task manually, through a variety of methods. We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. I only want to keep the first unique weight value, all duplicate values can be deleted.Įxcel 2007 introduced a really neat feature, Remove Duplicates, which makes it very easy to remove any duplicate values in a range of data. Excel propose easy and very fast way to create a chart by using shortcut keys.

Some of the Weight values repeat as you can see in the picture. The Date values are for each day and extend to the end of June. There are two columns of data, with Date in column A and Weight in column B. I have a worksheet with duplicate values that need to be removed.

Microsoft excel shortcut keys 2003