Medohh2120
Medohh2120
/ DynArray-ShapeShift.lambda
Last active
February 28, 2026 01:27
Excel LAMBDA: Replace columns/rows of a dynamic array
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| Name: REPLACE_INDICES | |
| Description: Replaces targeted rows and/or columns in an array with given "new_arrays". | |
| If multiple indices are supplied per axis, the same "new_array" is placed at each target. | |
| preserves the original order of the remaining rows/columns. | |
| Optional "pad_with" replaces dimension-mismatch errors in the final result. | |
| Made By: Medohh2120 | |
| */ | |
| REPLACE_INDICES = LAMBDA(array, [row_idxs], [new_row_array], [col_idxs], [new_col_array], [pad_with], |
Medohh2120
/ Repeat.lambda
Created
February 5, 2026 19:44
Repeats a data range based on a frequency column
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| Name: REPEAT | |
| Recommended version: v2024 or 365 | |
| Description: Repeats a data range based on a frequency column. | |
| Optimized with Binary Search. | |
| Made By: Medohh2120 | |
| */ | |
| Repeat = LAMBDA(Values,Number_times, | |
| LET( |
Medohh2120
/ Textbetween.lambda
Last active
February 28, 2026 00:11
Returns text between 2 delimiters
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| Name: TEXTBETWEEN | |
| Description: Returns text between delimiters. | |
| - Standardized to native TEXTAFTER/BEFORE syntax. | |
| - Supports Multi-input: Text (Rows) x Delimiters (Columns). | |
| - Strict Mode: Assumes equal number of start/end delimiters. | |
| Made By: Medohh2120 | |
| */ | |
| TEXTBETWEEN = LAMBDA(text, start_delim, end_delim, [instance_start], [instance_end], [case_sensitive_start], [case_sensitive_end], [match_end_start], [match_end_end], [if_not_found], |
Medohh2120
/ Unpivot_Toolkit.lambda
Last active
March 1, 2026 17:32
Wide" data into a "Long" database format
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| Name: UNPIVOT_PLUS | |
| Description: Given a table or a range with headers, Transforms "Wide" data into a "Long" database format. | |
| V4 UPDATE: "pad_blanks_with" feature to replace empty grid cells (prevents Pivot Table type-errors). | |
| Automatically handles merged cells (Fill-Down or Fill-Right logic). | |
| optionally removing Grid blank entries. | |
| optionally removing Grid errors. | |
| Made By: Medohh2120 | |
| */ |