Last version published: 06/05/2021 07:20
Publication number: ELQ-68372-2
View all versions & Certificate
Excel Column Filter tools
Three quick COLUMN FILTER utilities for Excel data tables (now also works with post-Excel 2007 ListObject 'Tables').
Michael Martin offers you this Best Practice for free!
download for free
Add to bookmarks
Save time when querying or analysing data in tables.
When working with a data table (with field descriptions in the first row and no blank rows or columns within it).
Where there are blank rows or columns within the data (although it will still work – it’s just that it can be more confusing!)
Write a review
People using this Best Practice also downloaded
More Best Practices from Michael Martin
De-select Active Cell from a selection with a VBA MacroDe-select a cell from a collection of selected cells/ranges in an Excel worksheet248add_shopping_cart
Excel ‘Conditional Paste’ Add-inA handy utility, a ‘must have’ for FINANCIAL MODELLERS and EXCEL DESIGNERS of dashboards and presentation materials.87add_shopping_cart
Any questions on Excel Column Filter Tools?
The user community and author are here to help. Go ahead!