Scribble Filter (For Excel) Overview Part 3

Points discussed in video:

The scribble filter is a text wrapper for the Advanced Filter in Excel, making it easy to work with and adding new capabilities.

  • Special Functions Defined @00:04
  • Top or bottom (also purpose for chaining) @00:30
  • Top or bottom by percent @02:10
  • Above or below average @02:52

Scribble Filter Home
Scribble Filter Help

Overview Part 1
Overview Part 2
Overview Part 3
Overview Part 4

Scribble Filter Overview Part 1

Points discussed in video: The scribble filter is a wrapper for the Advanced Filter in Excel, making it easy to work with and adding new capabilities. To get the date spans right click on the left calendar button. Use tab or enter to get the first line from the drop down menu. Right click on buttons to get more options (e.g., right click on report button to set type of report to create: On separate sheet, preview, in place, chain). [Read More]

AdvancedFilter: Parsing the Search String

One of the most difficult parts of creating an advanced filter class is figuring out how to parse the search data and turn it into a 2D array, which Excel can understand. I figured my user interface will be a string. So I started there. In my original implementation of the search algorithm it wasn’t very robust, so this time around I figured I would do it “right.” Well, right is a relative term. [Read More]