If you need to find a unique list of values in any column, there are a couple of ways to find the unique values in a column. Episode 364 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
I'm excited, we have two new books that came out this week.
“Excel for the CEO”, this is a great book for anyone new to Excel, or anyone trying to run a small business with Excel.
And my new book “Excel for Auditors”, talks about all the great ways that auditors can use Excel, using examples from the world of auditing.
And speaking of auditors, this Thursday, October 19th 2006, I'll be in New Jersey, right outside of New York City, doing a power Excel seminar for the Institute of Internal Auditors there.
Even if you're not an auditor, you're more than welcome to stop by for three hours, great Excel tips that are useful to everyone.
If you're not in New York City, upcoming dates, October 24th in Boise, October 27th in Akron, November 16th Columbus, Indiana, just south of Indianapolis.
Recently added November 17th in Cleveland, and November 30th in Green Bay, stop by the website for information on any of those.
I'd love to see you there, make sure to come up and say “Hey, we watch the podcast.” And be great to meet some of the people that are out there.
So hey, let's do a quick example from the Auditors book.
One of the kind of unusual tasks is in Excel, is we have a large database, we want to find unique list of customers.
Who are the customers who are in this five thousand rows of data?
The typical way that people try to do is with Advanced Filter, which is kind of hard to do.
I'm taking the Customer heading and copying it over to the right of my data, and then in the Data, Filter, Advanced Filter dialog box, I'm going to say that I want to Copy to another location.
And my Copy to: is the heading that has the Customer field, and check the box for Unique Records Only, click OK.
And there is my unique list of customers out on the right-hand side, kind of a lot of steps to go through.
My better way to do this, is to create a really simple Pivot table.
Select a single cell in your data, Data, PivotTable and PivotChart Report, click Finish, and then double-click the Customer field.
That's simple, you have a unique list of customers.
Now if you want to use this for anything, of course, you're going to copy it and Paste Special Values to wherever it needs to be, and then you could delete the Pivot table.
Using a Pivot table is a much faster way to create a unique list of anything!
Hey, thanks for stopping by, we'll see you next time for another netcast from MrExcel!
I'm excited, we have two new books that came out this week.
“Excel for the CEO”, this is a great book for anyone new to Excel, or anyone trying to run a small business with Excel.
And my new book “Excel for Auditors”, talks about all the great ways that auditors can use Excel, using examples from the world of auditing.
And speaking of auditors, this Thursday, October 19th 2006, I'll be in New Jersey, right outside of New York City, doing a power Excel seminar for the Institute of Internal Auditors there.
Even if you're not an auditor, you're more than welcome to stop by for three hours, great Excel tips that are useful to everyone.
If you're not in New York City, upcoming dates, October 24th in Boise, October 27th in Akron, November 16th Columbus, Indiana, just south of Indianapolis.
Recently added November 17th in Cleveland, and November 30th in Green Bay, stop by the website for information on any of those.
I'd love to see you there, make sure to come up and say “Hey, we watch the podcast.” And be great to meet some of the people that are out there.
So hey, let's do a quick example from the Auditors book.
One of the kind of unusual tasks is in Excel, is we have a large database, we want to find unique list of customers.
Who are the customers who are in this five thousand rows of data?
The typical way that people try to do is with Advanced Filter, which is kind of hard to do.
I'm taking the Customer heading and copying it over to the right of my data, and then in the Data, Filter, Advanced Filter dialog box, I'm going to say that I want to Copy to another location.
And my Copy to: is the heading that has the Customer field, and check the box for Unique Records Only, click OK.
And there is my unique list of customers out on the right-hand side, kind of a lot of steps to go through.
My better way to do this, is to create a really simple Pivot table.
Select a single cell in your data, Data, PivotTable and PivotChart Report, click Finish, and then double-click the Customer field.
That's simple, you have a unique list of customers.
Now if you want to use this for anything, of course, you're going to copy it and Paste Special Values to wherever it needs to be, and then you could delete the Pivot table.
Using a Pivot table is a much faster way to create a unique list of anything!
Hey, thanks for stopping by, we'll see you next time for another netcast from MrExcel!
