Learn Excel from Bill Jelen with this daily 2 minute video podcast.
In this Dueling Excel podcast, how to find the earliest date for records that match two criteria. Episode 1104 shows you how.
Labels: array formula, AutoFilter, Filter
posted by Bill at 9:00 AM
In today's dueling Excel podcast, the question is how to delete all the records which contain either ski or swim. This requires multiple wildcards in a filter. Mike and Bill will compare various methods in Episode 1090 .
Labels: Advanced Filter, Filter, formula, ISNUMBER, lookup
posted by Bill at 9:00 AM
Lisa from Chicago sends in today's question. Why can't you sort the page field in a pivot table? Episode 1059 talks about several ways to sort the row fields in a pivot table and then a method for sorting the filter field.
Labels: Filter, Pivot Table, Sorting
posted by Bill at 9:00 AM
Isabel asks how to use Ctrl+F to find a row where three criteria are true. Rather than use Ctrl+F, Episode 1044 suggests using a Filter.
Labels: Filter
posted by Bill at 9:00 AM
Ileane asks how to get only the .edu e-mail addresses from a database of 20,000 e-mails. Episode 1006 shows you how to use advanced filter with a criteria range to solve this problem.
Labels: Filter
posted by Bill at 9:00 AM
Another Dueling podcast: How to filter to the top 5 golf scores for one golfer? The AutoFilter won't let you do it. But Mike and Bill show you how in Episode 1005.
Labels: Filter
posted by Bill at 9:00 AM
Peter asks how to return multiple records from a VLOOKUP. In Episode 1002, I will show you how to use an Advanced Filter to achieve this result.
Labels: Advanced Filter, Filter
posted by Bill at 9:00 AM
Gary sends in a clever solution for Episode 977 which uses the Skip Blanks option of the Paste Special dialog. Watch for how Gary can "reverse" the filtered and hidden rows during the steps shown in Episode 981.
Labels: Filter, Paste Special
posted by Bill at 9:00 AM
Joe asks if there is any way to do a Filtered Paste operation. I can't figure it out, so I had to resort to a macro. Check out Episode 977 and see if you have a better way.
Labels: accounting, business, Excel, Filter, MrExcel, spreadsheets, technology, tutorial
posted by Bill at 9:00 AM
Loh from Malaysia sends in a very hard question. How can you use COUNTIF to analyze only the visible rows from a filtered data set? I knew the solution would have to involve iterating through multiple SUBTOTAL functions, but Aladin from the MrExcel Message board provides the solution. Episode 946 shows you how.
posted by Bill at 9:00 AM
Beardless Rot wants to know how to sort filtered data so that the top 10 autofilter will show items high-to-low. Episode 903 will show you how.
Labels: AutoFilter, Data Analysis, Filter
posted by Bill at 9:00 AM
Wiebe points out a better solution for Episode #838 - Excel already has an icon for Filter by Selection. It is hard to find and poorly labeled, but it is in there. Episode 851 shows you how.
Labels: Filter
posted by Bill at 9:00 AM
Say that you need to add up all of the red cells. This is easier in Excel 2007 using Filter by Color. Episode 816 will show you how to do this in Excel 2007 as well as a clever trick using find by format to do the same thing in Excel 2003.
Labels: Excel 2007, Filter
posted by Bill at 9:00 AM
Normally, you can not use AutoFilter within a pivot table. Today, Dan from Philly shares an amazing hack that allows you to filter the results of the pivot table. Episode 793 shows you how.
Labels: Filter, Pivot Table
posted by Bill at 9:00 AM
Excel 2007 offers amazing new AutoFilter functionality. Instead of choosing a single customer from the dropdown, you can filter a dataset to show 3 or more customers, or use new virtual filters to show all records from next month or last year. Episode 428 shows you how.
Labels: AutoFilter, Filter
posted by Bill at 9:00 AM
