FastExcel SpeedTools Filters

FastExcel SpeedTools Filters - high-performance dynamic sorting, distinct/uniques and multiple-condition filtering and aggregating

SpeedTools Multiple-Condition Filtering

  • Replace slow array formulas and SUMPRODUCT with fast FILTER.IFS functions.
  • Super fast performance on sorted data.
  • Use the Filter functions either inside functions like RANK, MAX, MIN, SUM, COUNT, COUNTA, AVERAGE MEDIAN, MODE, LARGE or as multi-cell array formulas
  • FILTER.IFS extended criteria provide much more power than SUMIFS
    • Full set of Relational operators including NOT
    • Regex and wildcard operators
    • Data Type filters #ERR, #TXT, #N, #BOOL, #EMPTY, #ZLS, #TYPE, #BLANK
    • Inclusion or exclusion Lists from arrays or ranges
    • Alternative OR groups of criteria
    • Expressions and calculated columns allowed as criteria columns
    • Criteria columns can be a range or a labelled column
  • FILTER.VISIBLE, FILTER.MATCH, FILTER.SORTED, ASUMIFS, ACOUNTIFS, Rgx.COUNTIF, Rgx.SUMIF

SpeedTools LISTDISTINCTS Family of functions

These functions provide efficient and flexible methods to work with distinct items or distinct rows in ranges or arrays of data.
The functions can be embedded inside other functions that process arrays or entered as multi-cell array formulas.

Options are available for:

  • Single-cell counts of DISTINCTS or DUPLICATES
  • Sorted ascending or descending or unsorted list of distinct items or rows
  • Sums, Counts or Averages for the list of distinct items (LISTDISTINCTS.SUM, LISTDISTINCTS.COUNT, LISTDISTINCTS.AVG)
  • Sorted ascending or descending on the Sums/Counts/Averages
  • Case-sensitivity
  • Distinct Rows or Cells
  • What to show in unused cells
  • Ignoring error values, blanks or zeros
  • Can process the output from embedded FILTER.IFS functions

SpeedTools Sorting Functions

The 6 dynamic sorting functions can be used to return sorted arrays with mixed ascending or descending columns.
The sort method used can either be compatible with Excel's SORT or use a faster method.
The output can either be a sorted list or an array of sorted indexes.
Sorting can optionally be case-sensitive.

Free Copy of SpeedTools Calc

SpeedTools Filters gives you all the additional calculation control and options of SpeedTools Calc, at no extra charge.

Try it for yourself!

Download the 15-day full-featured trial of FastExcel V3 build 232.656.791.380

Note: the trial version of FastExcel V3 profiler does not enable Profile Workbook, Profile Worksheet and Profile Formulas, and the Drill down wizard will only profile a single worksheet.

You can convert the trial version of FastExcel V3 to a fully licensed version at any time by purchasing one of the FastExcel V3 licensing options.

 

 

© 2001-2014 Decision Models  Legal Disclaimer Privacy Statement E-Mail Webmaster