Andrew Moss andrewcharlesmoss
🖥️
andrewcharlesmoss
/ FLATTEN.txt
Created
March 17, 2022 17:38
FLATTEN function to flatten all the values from one or more ranges into a single column
This file contains 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
| FLATTEN = | |
| LAMBDA(array, | |
| LET( | |
| rows,ROWS(array), | |
| columns,COLUMNS(array), | |
| sequence,SEQUENCE(rows*columns), | |
| quotient,QUOTIENT(sequence-1,columns)+1, | |
| mod,MOD(sequence-1,columns)+1, |
This file contains 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
| // v2 | |
| /* UPDATE 13/02/2022 | |
| Added columns argument and made each optional | |
| */ | |
| // Returns an array of unique random numbers | |
| RANDUNIQUE = | |
| LAMBDA([rows],[columns],[min],[max], |