Medohh2120
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
January 28, 2026 17:22
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_Plus.lambda
Last active
February 7, 2026 22:19
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. | |
| V3 UPDATE: Now supports multi-row headers and multi-column anchors. | |
| Automatically handles merged cells (Fill-Down or Fill-Right logic). | |
| optionally removing Grid blank entries. | |
| optionally removing Grid errors. | |
| Made By: Medohh2120 | |
| */ |