Skip to content

Instantly share code, notes, and snippets.

View andrewcharlesmoss's full-sized avatar
🖥️
Working on spreadsheets.

Andrew Moss andrewcharlesmoss

🖥️
Working on spreadsheets.
View GitHub Profile
@ExcelRobot
ExcelRobot / ArrayManipulation.lambda
Last active May 4, 2024 08:25
Array Manipulation LAMBDA Functions
/*
Excel Array Manipulation LAMBDA functions
Courtesy of Excel Robot
The Microsoft Excel team recent released 11 new Excel functions for combining, shaping, and resizing arrays.
I had already created similar ones for myself using the amazing LAMBDA function. Since the new functions
are only available to users running Beta Channel, I've renamed my versions and given them the same function
names so anyone with LAMBDA and LAMBDA helper functions (like MAKEARRAY), and import these LAMBDAs into your
workbook and have nearly the same functionality.