 
|
Someone emailed me for help with an Excel AutoFilter last week. He wanted to type the criteria onto a worksheet, and have the filtered results shown automatically. There are some built-in options for filtering by text, and keep reading to see a worksheet version that Roger Govier designed. AutoFilter Search in Excel 2010 There is [...] It's hard to believe that Excel Advanced Filter Week is drawing to a close. I hope that the three filter feeding shark species, and you, have enjoyed this tribute to Discovery Channel's Shark Week. Today, we'll see how to record a macro while using the Advanced Filter, and edit that macro, so it will [...] On Monday, we declared this Excel Advanced Filter Week, in honour of the three filter feeding shark species. Who said Excel wasn’t exciting? Today, we’ll see how to use the Advanced Filter to select only the items that are in a list, when running the filter. Advanced Filter Criteria Range For this Advanced Filter, [...] Last year, we celebrated the Discovery Channel's Shark Week, by using the LARGE and FLOOR functions. This year, we'll pay tribute to the three known species of sharks that are filter feeders, by declaring this Excel Advanced Filter Week. Yes, we'll have three fun-filled, action-packed days of Excel filtering fabulousness – one [...] With data validation and some programming, you can select multiple items from a drop down list, and show the selections in a single cell. That technique is helpful in some situations, but it can make filtering difficult. With an AutoFilter turned on, only the combined results show in the filter options, not the individual [...] Last week, we used the Excel SUBTOTAL function to sum items in a filtered list, while ignoring the hidden rows.
In the comments for that blog post, Sam mentioned that you can also use SUBTOTAL with functions like SUMPRODUCT, to do additional sums or counts, based on the visible data in a filtered [...] Do you ever use the Excel Advanced Filter feature? Or is all your filtering done with an AutoFilter? AutoFilter BenefitsFor ease of use, it's hard to beat the Excel AutoFilter feature. Just click the Filter command on the Excel Ribbon's Data tab, and the filter is ready to go.
You can [...] Now that the 30 Excel Functions in 30 Days challenge has ended, it's time to look at a few other features. On the Contextures page on Facebook, Lee suggested AutoFilters as a topic for some February posts. Thanks Lee! Filters in Excel TablesWhen you create an Excel Table in Excel 2007 or Excel 2010, [...] Here's the final video update for this week -- Automatically Copy Excel Data to Another Sheet. This video now shows the steps in Excel 2010 or Excel 2007, instead of Excel 2003. To wrap up this week of updates, here are links to a few of my previous Excel Advanced Filter articles and posts. You [...] In Excel 2003, and earlier versions, an AutoFilter allows only two criteria for each column. If you want to filter for multiple criteria, you can use an Advanced Filter. List all the criteria on a worksheet, and use that list (and its heading cell) as the criteria range. In Excel 2007 and Excel 2010, the [...]  |
|
|
Copyright © 2012 Contextures Blog - All Rights Reserved |
||
