For Excel Blackbelts: a well-hidden bug
Autofilters were the predecessors to Excel tables and are still sometimes used to filter data. An Excel bug means autofilter ranges can be misstated, hindering automated spreadsheet management.
This article looks at:
- Why this bug matters
- Challenge: identify and solve the bug
- When this bug appears
- A solution
- Some near misses and fails
You may want to skip from 1 to 3.
Autofilter bug: full description, resources and solution
Rather than type lots into a text editor with output to the web page, I’ve supplied a PDF and solution spreadsheet. You can share, copy, paste etc:
- Excel Autofilter Bug - PDF - full article
- Excel Autofilter Bug - spreadsheet clues and solution (has safe VBA)