Function
Type
Test
Result

AT
AT(['a', 'b', 'c', 'd', 'e'], [0, 2, 4])
['a', 'c', 'e']

COMPACT([0, 1, false, 2, '', 3])
[1, 2, 3]

DIFFERENCE([1, 2, 3, 4, 5], [5, 2, 10])
[1, 3, 4]

ESCAPE('Moe, Larry & Curly')
Moe, Larry & Curly'

FIRST([1, 2, 3], 2)
[1, 2]

FLATTEN([1, [2], [3, [[4]]]], true)
[1, 2, 3, [[4]]]

GROUPBY(['one', 'two', 'three'], 'length')
{ '3': ['one', 'two'], '5': ['three'] }

INDEXOF([1, 1, 2, 2, 3, 3], 2, true)
2

INITIAL([1, 2, 3], 2)
[1]

INTERSECTION([1, 2, 3], [101, 2, 1, 10], [2, 1])
[1, 2]

INVOKE([[5, 1, 7], [3, 2, 1]], 'sort')
[[1, 5, 7], [1, 2, 3]]

KEYS({ 'one': 1, 'two': 2, 'three': 3 })
['one', 'two', 'three']

LAST([1, 2, 3], 2)
[2, 3]

LASTINDEXOF([1, 2, 3, 1, 2, 3], 2, 3)
1

OMIT({ 'name': 'moe', 'age': 40 }, 'age')
{ 'name': 'moe' }

PAIRS({ 'moe': 30, 'larry': 40 })
[['moe', 30], ['larry', 40]]

PARSEINT('08')
8

PICK({ 'name': 'moe', '_userid': 'moe1' }, 'name')
{ 'name': 'moe' }

PULL([1, 2, 3, 1, 2, 3], 2, 3)
[1, 1]

RANGE(0, 30, 5)
[0, 5, 10, 15, 20, 25]

REST([1, 2, 3], 2)
[3]

SORTINDEX([20, 30, 50], 40)
2

UNESCAPE('Moe, Larry & Curly')
Moe, Larry & Curly'

UNION([1, 2, 3], [101, 2, 1, 10], [2, 1])
[1, 2, 3, 101, 10]

UNIQ([1, 1, 2, 2, 3], true)
[1, 2, 3]

UNZIP(['moe', 'larry'], [30, 40], [true, false])
[['moe', 30, true], ['larry', 40, false]]

VALUES({ 'one': 1, 'two': 2, 'three': 3 })
[1, 2, 3]

WITHOUT([1, 2, 1, 0, 3, 1, 4], 0, 1)
[2, 3, 4]

ZIP
ZIP(['moe', 'larry'], [30, 40], [true, false])
[['moe', 30, true], ['larry', 40, false]]

ZIPOBJECT(['moe', 'larry'], [30, 40])
{ 'moe': 30, 'larry': 40 }


Copyright © Sutoiku, Inc. 2012, 2014 | Excel is a registered trademark of Microsoft Corporation | Google Spreadsheets is a trademark of Google, Inc.