FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week


Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

April 5, 2016

Hi fellow Excel Addict,

Another spring day, another snowstorm in the forecast. Luckily, we haven't been getting everything the forecast calls for. There was supposed to be a big snowfall today. Instead we're just getting gently falling snow. Last Saturday it was sunny and 17C (63F). Today is snowing and 0C (32F).

Three seasons in a week...

Newfoundland weather pic by Francis Hayes (The Excel Addict.com)
In last Thursday's 'Excel in Minutes' newsletter, I showed you how to 'Make Your Custom Number Formats Available to All Workbooks'. If you missed it you can read it here.

If you have a favourite tip that you'd like to share, or a problem that you've been trying to solve, that I could possibly include in my newsletter, please send it along to me.

Wishing you an AWESOME week,
Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com


Francis Hayes (TheExcelAddict.com)

TheExcelAddict.com Quote of the Day

"Be more concerned with your character than your reputation,
because your character is what you really are,
while your reputation is merely what others think you are"
-- John Wooden -- 




If you missed my last newsletter, you can click here to view it online.



Excel in Seconds with TheExcelAddict.com

Two Easy Methods to Extract Unique Items From a List

You'll sometimes have large lists that you need to pull out all of the unique items. Here are a couple of quick and easy ways to do this.

Pivot Table Method
The first option is to use a Pivot Table. Even if you don't know how to use Pivot Tables, this one is super easy.

1) Select the column of data that you want to create the unique list of items from;

Extract Unique Items From List Pivot Table in Microsoft Excel 2007 2010 2013 2016 365

2) From the Insert tab, click Pivot Table in the Tables group and click OK. This will add a new sheet to your workbook containing a blank Pivot Table;

3) On the right side of your screen you will see the Pivot Table Field List showing only one item. Drag this item down to the Row Labels area below and the unique list of values will 'magically' appear in your worksheet.

Extract Unique Items From List Pivot Table in Microsoft Excel 2007 2010 2013 2016 365
If you want, you can copy these values elsewhere and then delete the sheet containing the Pivot Table.

Remove Duplicates Method
For the next method, to get a list of unique items, we just have to remove the duplicate items.

1) I
f you don't want to mess up your original data, copy your list to another sheet or workbook;

Extract Unique Items Remove Duplicates 1 in Microsoft Excel 2007 2010 2013 2016 365
2) With your list selected, from the Data tab and click the Remove Duplicates. If your data is in just one column, click OK and all the duplicates will be removed leaving just the unique values.

Extract Unique Items Remove Duplicates 2 in Microsoft Excel 2007 2010 2013 2016 365

Simple as that !!



Thanks for supporting this newsletter and website

FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week


Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630