SpeedTools Extra contains 29 useful extra functions for Arrayhandling,
Logical, Math, Text and Information.
ArrayHandling Functions
These arrayhandling functions
allow you to
 Mix constant arrays
and range references.
 Stack ranges and/or
arrays alongside or below one another.
 Pad the unfilled cells
of arrays with blanks, zeros or #N/A
The array functions are:
 COL.ARRAY  Appends
Ranges/Arrays columnwise
 ROW.ARRAY  Appends
Ranges/Arrays rowwise
 REVERSE.ARRAY  Reverse
the rows, columns or both in an array.
 PAD.ARRAY  Resize and/or
pad an array
 VECTOR  Outputs a sequence
of numbers as a column or row vector.
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
errorhandling version of IFERROR
Math Functions
 LINTERP2D  Fast 2dimensional
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
textstrings to a fixed length
 REVERSE.TEXT  Reverse
the characters in a Textstring
 SPLIT.TEXT  Splits
text into tokens using delimiters
 GROUPS  Extracts groups of characters or digits
from a Textstring
 Rgx.FIND  Find the
position of a RegEx pattern within a textstring
 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 nonempty visible column.
 COUNTROWS  Counts the
number of rows to the last nonempty 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.
Try it for yourself!
Download
the 15day fullfeatured 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.
