Logo Help center
Sign in
English (US) Español
  • Home
  • Community
  • Submit a request
sidebar image
  1. Help center
  2. Reference Manual
  3. Utilities

Utilities

Follow New articles New articles and comments

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
© Help center
  • About us
  • Download
  • Buy
  • Contact us