• Contents
  • Search
  • FXLV4SpeedTools
    • FXLV4SpeedTools
    • SpeedTools Overview
    • SpeedTools Array-Handling Functions
      • Array totalling and arithmetic functions
      • Dynamic Array shaping functions
      • Dynamic comparison and mergeing of ranges and arrays
      • Dynamic sorting functions
      • The Family of LISTDISTINCT Functions
      • High-Performance FILTER.IFS family of functions
      • New Family of AND and OR functions designed for Array Formulas.
    • SpeedTools High-Performance Functions
      • High-Performance AVLOOKUP2 family of functions
      • Regular Expression Functions
      • 10 New Text-handling Functions
      • New Math and Statistics functions
    • Getting Started with FastExcel SpeedTools
      • Installing FastExcel V4 SpeedTools
      • FastExcel V4 SpeedTools Prerequisites
      • The SpeedTools Ribbon
      • Excel Function Intellisense
      • Excel Function Wizard
      • SpeedTools Functions by Category
      • SpeedTools Functions Properties
    • Dynamic Array Formats
      • Edit DA Formats
      • Show DA Formats
    • Array totalling and arithmetic functions
      • ACCUMULATE Function
      • DIFF Function
      • MOVAVG Function
      • TOTALS & AGGREGATES Functions
      • HTOTALS Function
      • SUMCOLS Function
      • SUMROWS Function
      • AVERAGECOLS Function
      • AVERAGEROWS Function
      • COUNTCOLS Function
      • COUNTROWS Function
      • CORKSCREW Function
    • Array shaping functions
      • UNPIVOT Function
      • SLICES Function
      • SPLICECELLS function
      • SPLICEROWS function
      • SPLICECOLS function
      • RESIZE Function
      • REPEAT Function
      • VSTACK & VSTACKF Functions
      • HSTACK & HSTACKF Functions
      • HDR.VSTACK Function
      • HDR.HSTACK Function
      • REVERSE.ARRAY Function
      • VECTOR Function
    • Join, Compare and Merge Functions
      • MISSMATCHES
      • MATCHES
      • MISSMATCHES and MATCHES Examples
      • COMPARE.LISTS Function
      • COMPARE.LISTS Examples
      • LISTDISTINCTS Function
      • LISTDISTINCTS.COUNT Function
      • LISTDISTINCTS.SUM Function
      • LISTDISTINCTS.AVG Function
      • COUNTDISTINCTS Function
      • COUNTDUPES Function
      • LISTDISTINCTS Examples
    • Array Sorting Functions
      • VSORTC – Dynamic text collating Sort of a vertical range or array
      • Case.VSORTC – Case-sensitive dynamic Sort of a vertical range or array
      • VSORTB – Fast Dynamic Sort of a vertical range or array
      • VSORTC.INDEX – Collating Text Index Sort of a vertical range or array
      • Case.VSORTC.INDEX – Collating Text Index Sort of a vertical range or array
      • VSORTB.INDEX – Fast Index Sort of a vertical range or array
    • Logical Functions for Array Formulas
      • OR.ROWS, OR.COLS, OR.CELLS, AND.ROWS, AND.COLS, AND.CELLS, ALL, ANY, NONE
      • Examples of SpeedTools Logical Functions:
    • Array and Range Filtering Functions
      • The FILTER.IFS Multiple Criteria Function Family
      • FILTER.IFS function
      • FILTER.IFS and ASUMIFS Examples
      • FILTER.SORTED function
      • FILTER.MATCH function
      • ASUMIFS function
      • ACOUNTIFS function
      • FILTER.VISIBLE function
      • Rgx.COUNTIF function
      • Rgx.SUMIF function
    • Lookup and Match Functions
      • Outstanding Performance
      • Advanced Function
      • Better, Safer Lookup Defaults
      • SpeedTools Lookup Families
      • High-performance exact match Memory Lookups
      • The 24 Advanced Function Lookups
      • MEMLOOKUP Function
      • MEMMATCH Function
      • AVLOOKUP2, AVLOOKUPS2 & AVLOOKUPNTH Functions
      • AVLOOKUP2 Examples
      • Case.AVLOOKUP2, Case.AVLOOKUPS2 & Case.AVLOOKUPNTH Functions
      • AMATCH2, AMATCHES2 & AMATCHNTH functions
      • Case.AMATCH2, Case.AMATCHES2 & Case.AMATCHNTH functions
      • Rgx.AVLOOKUP2, Rgx.AVLOOKUPS2 & Rgx.AVLOOKUPNTH Functions
      • Rgx.Case.AVLOOKUP2, Rgx.Case.AVLOOKUPS2 & Rgx.Case.AVLOOKUPNTH Functions
      • Rgx.AMATCH2, Rgx.AMATCHES2 & Rgx.AMATCHNTH functions
      • Rgx.Case.AMATCH2, Rgx.Case.AMATCHES2 & Rgx.Case.AMATCHNTH functions
      • EVAL2 function: evaluate a string
    • Mathematical Functions
      • VLINTERP2 function
      • LINTERP2D function
      • Calculating Gini Coefficients with GINICOEFF
      • GINICOEFF function
      • IFERRORX Function
    • Reference Functions
      • PREVIOUS Function
      • SETMEM and GETMEM Functions
    • Information Functions
      • HASFORMULA2 function
      • Calculation Sequence and Counting functions
      • CALCSEQCOUNTREF Function
      • CALCSEQCOUNTSET Function
      • CALCSEQCOUNTVOL function
      • Functions for counting Rows and Columns
      • COUNTROWS2 Function
      • COUNTCONTIGROWS2 Function
      • COUNTUSEDROWS2 Function
      • COUNTCOLS2 Function
      • COUNTCONTIGCOLS2 Function
      • COUNTUSEDCOLS2 Function
      • Examples and comparison of the counting functions
      • Using the Count functions in dynamic range names
    • Text Functions
      • CONCAT.RANGE – concatenate range data
      • PAD.TEXT function
      • REVERSE.TEXT Function
      • SPLIT.TEXT Function
      • GROUPS Function
      • Rgx.FIND function
      • Rgx.LEN function
      • Rgx.SUBSTITUTE function
      • Rgx.MID function
      • COMPARE function
      • ISLIKE2 array function for pattern-matching strings
      • Rgx.ISLIKE function
    • SpeedTools Calculation Manager
      • Calculation Manager Options and Settings
      • Excel Calculation Settings
      • Excel Current Calculation Mode
      • FastExcel Active Workbook Mode
      • Excel Set Book Modes
      • Excel Calculation Settings: Initial Calculation Mode
      • Excel Calculation Buttons
      • Workbook Calculation Settings
        • Workbook Calculation Settings: Mixed Mode
        • Workbook Calculation Settings: Workbook Options
      • FastExcel Settings
      • Getting Consistent Results from FastExcel V4 Timing
    • SpeedTools Run-Time
    • Calling SpeedToolsFunctions from VBA
    • Using FastExcel calculation methods from VBA
      • MICROTIMER function
      • MILLITIMER function
      • STRCOLID function
Match: