-
1 min read
Description Provides the ability to link data from Excel to Word. (Simplest way) NOTES Syntax SETTINGS Settings for tables and…
-
1 min read
Description Provides the ability to create, read, or write data to a RegistryKey from a given path. NOTES Syntax EXAMPLE…
-
1 min read
Description Provides screenshot capabilities on Excel or Active Window. NOTES Syntax EXAMPLE 1 Take a full screen screenshot and copy…
-
1 min read
Description Provides the ability to generate a BARCODE image from a specified string. NOTES Syntax EXAMPLE 1 Generate BARCODE Code128…
-
Description Returns a value or reference based on its row and column position within that array or reference. NOTES Syntax…
-
Description Searches a range or an array then returns the item corresponding to the first match it finds. NOTES Syntax SAMPLE data EXAMPLE…
-
Description Searches an element and returns its relative position in the given array or reference. NOTES Syntax SAMPLE data EXAMPLE…
-
Description Searches an element and returns its relative position in the given array or reference. NOTES Syntax SAMPLE data EXAMPLE…
-
Description Returns a list of unique values in a list or range. NOTES Syntax INPUT DATA EXAMPLE 1 RELATED
-
1 min read
Description Provides access to a computer’s file system. NOTES Syntax EXAMPLE 1 Get the names of all files from a…
-
Description Build an expression (new lambda function) based on input parameters. NOTES Syntax EXAMPLE 1 EXAMPLE 2 EXAMPLE 3 RELATED
-
Description Returns an aggregate in a list or database. NOTES Syntax rULES SAMPLE DATA EXAMPLE 1 RELATED
-
Description Evaluate expressions through intermediate variables. NOTES Syntax SAMPLE data EXAMPLE 1 EXAMPLE 2 RELATED
-
Description Returns the character specified by a number. NOTES Syntax EXAMPLE 1 RELATED
-
Description Returns the position of the first character of the search string in the original string beginning with start_num. NOTES…
-
Description Returns the sum of the numbers appearing in the provided values. NOTES Syntax SAMPLE data EXAMPLE 1 RELATED
-
Description Returns the absolute value of a number. Syntax SAMPLE data EXAMPLE 1 RELATED
-
Description Identify the language used in a specified text using Microsoft Translation Services. NOTES Syntax SAMPLE data EXAMPLE 1 RELATED
-
Description Combines the text from multiple ranges or arrays. NOTES Syntax SAMPLE data EXAMPLE 1 RELATED
Join our newsletter to stay up to date
Click the button below to sign up for our advanced SaaS platform. Get started now and see the benefits for yourself.
Email address