Utilities

NumXL also features a number of functions that do not fit into our main function categories. These "orphan" functions, including interpolation, extrapolation, excess kurtosis of a GED/Student’s t distribution, are grouped together in the "utilities" category

• NxFold - Convert a 3 columns into a 2-D table or matrix
• NxFlatten - collapse a data table into a flat 3-columns form.
• NUMXL_INFO - Installation Information
• NxArray - Create an array using constants and/or cells references
• HASNA - Check input for observations with missing Value
• MV_OBS - Number of observations with non-missing values
• MV_VARS - Effective Number of Variables
• NxMatch - Regular Expression (regex) Match Function
• NxReplace - Regular Expression (regex) Replace Function
• NxTokenize - Separate a string by a delimiter into an array of substrings
• NxTranspose - Convert row to column (and vice versa)
• RMNA - Remove Missing Values