Excel 2007 offers powerful new features for removing duplicates. Episode 415 shows how you can find the unique values in a list using just a couple of clicks.
This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!
This blog is the video netcast companion to the upcoming book, Excel 2007 Miracles Made Easy. Download a new two minute video every Tuesday and Thursday to learn one of the tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Well, we have 26 days until Excel 2007 hits the store shelves on January 30th 2007.
Now today is a 2007 Thursday, so let me show you one of the cool new tricks that have coming in Excel 2007.
And one of the problems we always have in Excel, is that there is a large list or database, or something like that, and we need to figure out who the unique values are in one of those columns.
Well, this has become much easier in Excel 2007.
I have a list here of some invoices, it has date, customer and sales, I want to figure out who the unique customers are in this list.
We go and select the Data ribbon and on the Data ribbon there is an option there, called Remove Duplicates.
I'll choose Remove Duplicates, inside that I want to look for Duplicates within just the Customer field so I'll leave that checked, click OK and in a second Excel has removed the 10 duplicate values, leave me just the 9 unique customers.
Now one caution, this is a really destructive function, those other rows are just gone.
You want to make sure to always make a copy of your data set before you use Remove Duplicates.
It is possible to get it back with undue, Ctrl+Z will bring it back, but just get in the habit of making a copy of the data set first, then using Remove Duplicates to find the unique values.
Hey, thanks for stopping by, we’ll see you tomorrow for another netcast from MrExcel.
Well, we have 26 days until Excel 2007 hits the store shelves on January 30th 2007.
Now today is a 2007 Thursday, so let me show you one of the cool new tricks that have coming in Excel 2007.
And one of the problems we always have in Excel, is that there is a large list or database, or something like that, and we need to figure out who the unique values are in one of those columns.
Well, this has become much easier in Excel 2007.
I have a list here of some invoices, it has date, customer and sales, I want to figure out who the unique customers are in this list.
We go and select the Data ribbon and on the Data ribbon there is an option there, called Remove Duplicates.
I'll choose Remove Duplicates, inside that I want to look for Duplicates within just the Customer field so I'll leave that checked, click OK and in a second Excel has removed the 10 duplicate values, leave me just the 9 unique customers.
Now one caution, this is a really destructive function, those other rows are just gone.
You want to make sure to always make a copy of your data set before you use Remove Duplicates.
It is possible to get it back with undue, Ctrl+Z will bring it back, but just get in the habit of making a copy of the data set first, then using Remove Duplicates to find the unique values.
Hey, thanks for stopping by, we’ll see you tomorrow for another netcast from MrExcel.
