Posts tagged ‘AutoFilter’
Filter Dropdowns: Podcast #1310
Move the AutoFilter dropdowns from row 1 of your worksheet . . .
Filling Blanks Uh-Oh – 1146 – Learn Excel from MrExcel Podcast
Mark asks how to fill blanks in with the data from above. Now…if you’ve watched this podcast, you’ve seen the trick for this, but Mark’s data has something preventing Go To Special Blanks from working! So – another way to go. Episode 1146 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!
AutoFilter Some – 1136 – Learn Excel from MrExcel Podcast
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!
Duel: Earliest Matching 2 – 1104 – Learn Excel from MrExcel Podcast
In this Dueling Excel podcast, how to find the earliest date for records that match two criteria. Episode 1104 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!
Episode 903 – Sorting AutoFilter
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.
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!
Episode 597 – Show All
After you’ve used an AutoFilter to see just a few records, how can you quickly show all records? Episode 597 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!
Episode 572 – 2007 Filters
Excel 2007 adds some amazing new features to the Excel 2003 AutoFilter technology. Learn how you can filter to multiple items, by month or by color. Episode 572 shows you how.
This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every workday to learn one of the tips from the book!
Episode 571 – AutoFilter Doesn’t Contain
Joe asks about using custom autofilters with Excel. He can use a wildcard to find all of the cells that contain *abc*, but how about finding cells that do not contain “abc”? Episode 571 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!
Episode 546 – Adding Headings
Today’s problem involves a complex data set with headings throughout the data. We want to add new columns to the dataset, but it is incredibly tedious to copy the new column headings throughout the report. Episode 546 shows you how to use a combination of AutoFilter, and Visible Cells Only to solve the problem.
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!
