|
|
SpeedTools Functions by Category
|
Name
|
SpeedTools Category
|
Excel Category
|
|
ACCUMULATE
|
Array
|
Math & Trig
|
|
ACOUNTIFS
|
Filters
|
Statistical
|
|
ALL
|
Logical
|
Logical
|
|
AMATCH2
|
Lookups
|
Lookup & Reference
|
|
AMATCHES2
|
Lookups
|
Lookup & Reference
|
|
AMATCHNTH
|
Lookups
|
Lookup & Reference
|
|
AND.CELLs
|
Logical
|
Logical
|
|
AND.COLS
|
Logical
|
Logical
|
|
AND.ROWS
|
Logical
|
Logical
|
|
ANY
|
Logical
|
Logical
|
|
ASUMIFS
|
Filters
|
Statistical
|
|
AVERAGECOLS
|
Array
|
Math & Trig
|
|
AVERAGEROWS
|
Array
|
Math & Trig
|
|
AVLOOKUP2
|
Lookups
|
Lookup & Reference
|
|
AVLOOKUPNTH
|
Lookups
|
Lookup & Reference
|
|
AVLOOKUPS2
|
Lookups
|
Lookup & Reference
|
|
CalcSeqCountRef
|
Information
|
Information
|
|
CalcSeqCountSet
|
Information
|
Information
|
|
CalcSeqCountVol
|
Information
|
Information
|
|
Case.AMATCH2
|
Lookups
|
Lookup & Reference
|
|
Case.AMATCHES2
|
Lookups
|
Lookup & Reference
|
|
Case.AMATCHNTH
|
Lookups
|
Lookup & Reference
|
|
Case.AVLOOKUP2
|
Lookups
|
Lookup & Reference
|
|
Case.AVLOOKUPNTH
|
Lookups
|
Lookup & Reference
|
|
Case.AVLOOKUPS2
|
Lookups
|
Lookup & Reference
|
|
Case.VSORTC
|
Sorting
|
Math & Trig
|
|
Case.VSORTC.INDEX
|
Sorting
|
Math & Trig
|
|
COL.ARRAY
|
Array
|
Lookup & Reference
|
|
COMPARE
|
Text
|
Text
|
|
COMPARE.LISTS
|
Lookups
|
Lookup & Reference
|
|
CONCAT.RANGE
|
Text
|
Text
|
|
CORKSCREW
|
Array
|
Math & Trig
|
|
COUNTCOLS
|
Array
|
Math & Trig
|
|
COUNTCOLS2
|
Information
|
Information
|
|
COUNTCONTIGCOLS2
|
Information
|
Information
|
|
COUNTCONTIGROWS2
|
Information
|
Information
|
|
COUNTDISTINCTS
|
Filters
|
Statistical
|
|
COUNTDUPES
|
Filters
|
Statistical
|
|
COUNTROWS
|
Array
|
Math & Trig
|
|
COUNTROWS2
|
Information
|
Information
|
|
COUNTUSEDCOLS2
|
Information
|
Information
|
|
COUNTUSEDROWS2
|
Information
|
Information
|
|
DIFF
|
Array
|
Math & Trig
|
|
EVAL2
|
Lookups
|
Lookup & Reference
|
|
FILTER.IFS
|
Filters
|
Lookup & Reference
|
|
FILTER.MATCH
|
Filters
|
Lookup & Reference
|
|
FILTER.SORTED
|
Filters
|
Lookup & Reference
|
|
FILTER.VISIBLE
|
Filters
|
Lookup & Reference
|
|
GETMEM
|
Lookups
|
Lookup & Reference
|
|
GINICOEFF
|
Math
|
Statistical
|
|
GROUPS
|
Text
|
Text
|
|
HASFORMULA2
|
Information
|
Information
|
|
HDR.HSTACK
|
Array
|
Lookup & Reference
|
|
HDR.VSTACK
|
Array
|
Lookup & Reference
|
|
HSTACK
|
Array
|
Lookup & Reference
|
|
HTOTALS
|
Array
|
Math & Trig
|
|
IFERRORX
|
Logical
|
Logical
|
|
ISLIKE2
|
Text
|
Text
|
|
LINTERP2D
|
Math
|
Math & Trig
|
|
LISTDISTINCTS
|
Filters
|
Statistical
|
|
LISTDISTINCTS.AVG
|
Filters
|
Statistical
|
|
LISTDISTINCTS.COUNT
|
Filters
|
Statistical
|
|
LISTDISTINCTS.SUM
|
Filters
|
Statistical
|
|
MATCHES
|
Lookups
|
Lookup & Reference
|
|
MEMLOOKUP
|
Lookups
|
Lookup & Reference
|
|
MEMMATCH
|
Lookups
|
Lookup & Reference
|
|
MISSMATCHES
|
Lookups
|
Lookup & reference
|
|
MOVAVG
|
Array
|
Math & Trig
|
|
NONE
|
Logical
|
Logical
|
|
OR.CELLS
|
Logical
|
Logical
|
|
OR.COLS
|
Logical
|
Logical
|
|
OR.ROWS
|
Logical
|
Logical
|
|
PAD.ARRAY
|
Array
|
Lookup & Reference
|
|
PAD.TEXT
|
Text
|
Text
|
|
PREVIOUS
|
Lookups
|
Lookup & Reference
|
|
REPEAT
|
Array
|
Lookup & Reference
|
|
RESIZE
|
Array
|
Lookup & Reference
|
|
REVERSE.ARRAY
|
Array
|
Lookup & Reference
|
|
REVERSE.TEXT
|
Text
|
Text
|
|
Rgx.AMATCH2
|
Lookups
|
Lookup & Reference
|
|
Rgx.AMATCHES2
|
Lookups
|
Lookup & Reference
|
|
Rgx.AMATCHNTH
|
Lookups
|
Lookup & Reference
|
|
Rgx.AVLOOKUP2
|
Lookups
|
Lookup & Reference
|
|
Rgx.AVLOOKUPNTH
|
Lookups
|
Lookup & Reference
|
|
Rgx.AVLOOKUPS2
|
Lookups
|
Lookup & Reference
|
|
Rgx.Case.AMATCH2
|
Lookups
|
Lookup & Reference
|
|
Rgx.Case.AMATCHES2
|
Lookups
|
Lookup & Reference
|
|
Rgx.Case.AMATCHNTH
|
Lookups
|
Lookup & Reference
|
|
Rgx.Case.AVLOOKUP2
|
Lookups
|
Lookup & Reference
|
|
Rgx.Case.AVLOOKUPNTH
|
Lookups
|
Lookup & Reference
|
|
Rgx.Case.AVLOOKUPS2
|
Lookups
|
Lookup & Reference
|
|
Rgx.COUNTIF
|
Filters
|
Math & Trig
|
|
Rgx.FIND
|
Text
|
Text
|
|
Rgx.ISLIKE
|
Text
|
Text
|
|
Rgx.LEN
|
Text
|
Text
|
|
Rgx.MID
|
Text
|
Text
|
|
Rgx.SUBSTITUTE
|
Text
|
Text
|
|
Rgx.SUMIF
|
Filters
|
Math & Trig
|
|
ROW.ARRAY
|
Array
|
Lookup & Reference
|
|
SETMEM
|
Lookups
|
Lookup & Reference
|
|
SLICES
|
Array
|
Lookup & Reference
|
|
SPLICECELLS
|
Array
|
Lookup & Reference
|
|
SPLICECOLS
|
Array
|
Lookup & Reference
|
|
SPLICEROWS
|
Array
|
Lookup & Reference
|
|
SPLIT.TEXT
|
Text
|
Text
|
|
SUMCOLS
|
Array
|
Math & Trig
|
|
SUMROWS
|
Array
|
Math & Trig
|
|
TOTALS
|
Array
|
Math & Trig
|
|
UNPIVOT
|
Array
|
Lookup & Reference
|
|
VECTOR
|
Array
|
Lookup & Reference
|
|
VLINTERP2
|
Math
|
Math & Trig
|
|
VSORTB
|
Sorting
|
Math & Trig
|
|
VSORTB.INDEX
|
Sorting
|
Math & Trig
|
|
VSORTC
|
Sorting
|
Math & Trig
|
|
VSORTC.INDEX
|
Sorting
|
Math & Trig
|
|
VSTACK
|
Array
|
Lookup & Reference
|
|
|
