Mary from Louisiana passes along a cool tip for applying AutoFilter dropdowns to a subset of your records. Episode 1136 shows you how.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Basically, you start out with massive amounts of data, and say “How we're going to analyze this?” Well, let's fire up a Pivot table and see if we can solve this problem!
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
I’m just out here cruising around at YouTube, search for “3 year old kid imitates mr excel”, and you'll see Mike Girvin’s son Isaac actually managed to come up with a couple of cool Excel tips, as he's a wandering around.
Kind of funny, obviously taken after his dear old dad there.
So hey, I got a great tip today, this came from the Power Analyst Boot Camp I was down in Dallas last week with Mike Alexander.
Someone there in the audience, Mary, gave me a great tip.
Now, of course, you know, if we turn on the AutoFilter drop-down, as it turns on AutoFilters for everything, and you know, he(?) was really going to come here to the revenue drop-down and choose one of these.
Pretty unlikely if you're creating this for someone else.
So Mary had a pretty cool tip, she said “Hey, if you just want to put the AutoFilter drop-downs on the first three,” now by the way, I know how to do that in VBA, but she had a non-VBA way to do it.
You just insert a column, come over here, apply the filter, drop-downs on A, B and C, and then delete the extra column, and a great, great way to go.
Now someone else in the audience pointed out that you could also achieve this by choosing those three columns and clicking Filter, that filters just those.
And of course, you know, once we then, choose one specific customer, it's going to filter all of the columns, but we only have to drop down on the relevant items.
Very, very cool tip to go, provided the columns you want are all adjacent, otherwise we need to go over to VBA to pull that off.
Alright well hey, I want to send a shout-out to Isaac who is apparently getting into the Excel podcast game.
Want to thank you for stopping by, we’ll see you next time for another netcast from MrExcel!
Well thanks for stopping by, we'll see you next time for another netcast from MrExcel!
Basically, you start out with massive amounts of data, and say “How we're going to analyze this?” Well, let's fire up a Pivot table and see if we can solve this problem!
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
I’m just out here cruising around at YouTube, search for “3 year old kid imitates mr excel”, and you'll see Mike Girvin’s son Isaac actually managed to come up with a couple of cool Excel tips, as he's a wandering around.
Kind of funny, obviously taken after his dear old dad there.
So hey, I got a great tip today, this came from the Power Analyst Boot Camp I was down in Dallas last week with Mike Alexander.
Someone there in the audience, Mary, gave me a great tip.
Now, of course, you know, if we turn on the AutoFilter drop-down, as it turns on AutoFilters for everything, and you know, he(?) was really going to come here to the revenue drop-down and choose one of these.
Pretty unlikely if you're creating this for someone else.
So Mary had a pretty cool tip, she said “Hey, if you just want to put the AutoFilter drop-downs on the first three,” now by the way, I know how to do that in VBA, but she had a non-VBA way to do it.
You just insert a column, come over here, apply the filter, drop-downs on A, B and C, and then delete the extra column, and a great, great way to go.
Now someone else in the audience pointed out that you could also achieve this by choosing those three columns and clicking Filter, that filters just those.
And of course, you know, once we then, choose one specific customer, it's going to filter all of the columns, but we only have to drop down on the relevant items.
Very, very cool tip to go, provided the columns you want are all adjacent, otherwise we need to go over to VBA to pull that off.
Alright well hey, I want to send a shout-out to Isaac who is apparently getting into the Excel podcast game.
Want to thank you for stopping by, we’ll see you next time for another netcast from MrExcel!
Well thanks for stopping by, we'll see you next time for another netcast from MrExcel!
