Logical Functions

Simplify adding AND and
OR to your array formulas with SpeedTools logical functions.Excel's AND and OR functions do not work well in array
formulas. They return a single TRUE or FALSE rather than an array
of TRUEs and FALSEs.

ANDROWS - Logical AND
by rows

ANDCOLS - Logical AND
by columns

ANDEACH - Logical AND
by cell

ORROWS - Logical OR
by rows

ORCOLS - Logical OR
by columns

OREACH - Logical OR
by cell

ANY - scalar version
of Excel's OR with more sensible error handling

ALL - scalar version
of Excel's AND with more sensible error handling

NONE - equivalent to
NOT OR with more sensible error handling

COMPARE - Compare 2
values using Locale Collating rules

IFERRORX - Extended
error-handling version of IFERROR

Math Functions

LINTERP2D - Fast 2-dimensional
linear interpolation

VLINTERP2 - Fast linear
interpolation in a vertical table

GINICOEFF - Fast calculation
of the Gini inequality coefficient.

Text Functions

CONCAT.RANGE - Concatenate
cell values to a string using delimiters.

PAD.TEXT - Expand/Contract
text-strings to a fixed length

REVERSE.TEXT - Reverse
the characters in a Text-string

SPLIT.TEXT - Splits
text into tokens using delimiters

GROUPS - Extracts groups of characters or digits
from a Text-string

Rgx.FIND - Find the
position of a RegEx pattern within a text-string

Rgx.LEN - Finds the
length of the substring that matches a RegEx pattern

Rgx.SUBSTITUTE - Replaces
substring(s) that match RegEx patterns.

Rgx.MID - Extracts substrings
that match regular expressions

Information Functions

ISLIKE - wildcard pattern
testing for text strings

Rgx.ISLIKE - regular
expression pattern testing for text strings

ISFORMULA - returns
true if the cell contains a formula

Functions for use in dynamic
range names:

COUNTCONTIGCOLS - Counts
the number of contiguous visible volumns

COUNTCONTIGROWS - Counts
the number of contiguous visible rows

COUNTUSEDCOLS - Counts
the number of columns in the used range, starting from a reference.

COUNTUSEDROWS - Counts
the number of rows in the used range, starting from a reference.

COUNTCOLS - Counts the
number of columns to the last non-empty visible column.

COUNTROWS - Counts the
number of rows to the last non-empty visible row.

Functions for tracing formula
calculation sequence and volatility:

CalcSeqCountRef - counts
the number of times references have been calculated

CalcSeqCountVol - counts
the number of times this Excel session has calculated

CalcSeqCountSet - resets
the calculation counter

Free Copy of SpeedTools Calc

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