Range Manipulation family

Range Operations category Home 

ComponentWhat the name means
OneD Turn a range into a one dimensional, BF-style range
SortText array functionSort an array of text (strings)
SubList array functionCreate sub list based on true/false criteria
ApplyToList array functionApply a number to a list eg multiply. add etc
PickEveryNth array functionPick every Nth value from a list
CombineLists array functionCombine 2 lists of numerical values
TransposeNum array functionTranspose a number array
CreateList array functionCreat a list (range) of numbers or text from a series of cell references
TrimList array functionTrim a list (1 dimensional range)
JoinLists array functionJoin 1 or more lists (1 dimensional ranges)
Unique array functionExtract unique values from list