carlos barboza RecalcOrDie
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
| /* | |
| Name: VARIANCE | |
| Description: Variance | |
| Author: Carlos Barboza (inspired from a post on this formula by Mike Alexander aka DataPig) | |
| Category: Formula | |
| */ | |
| VARIANCE = LAMBDA( | |
| ThisYear, | |
| PriorYear, |
RecalcOrDie
/ Pivottable.lambda
Created
April 20, 2022 22:35
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
| /* | |
| Name: PIVOTTABLE | |
| Description: LAMBDA used to make a pivot table formula | |
| Author: Karina Adcock | |
| Category: Dynamic Arrays | |
| URL video: https://www.youtube.com/watch?v=VoB_cigX1hk | |
| */ | |
| PIVOTTABLE = LAMBDA( | |
| data, |
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
| /* | |
| Name: MEDIANIFλ | |
| Description: LAMBDA used to get MEDIANIF | |
| Author: Peter Bartholomew | |
| Category: Dynamic Arrays | |
| */ | |
| MEDIANIFλ = LAMBDA( | |
| CriteriaRange, | |
| CriteriaValues, |
RecalcOrDie
/ MEDIANIF.lambda
Created
May 5, 2022 01:15
LAMBDA used to find the median for the cells specified by a given condition or criteria
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
| /* | |
| Name: MEDIANIF | |
| Description: LAMBDA used to find the median for the cells specified by a given condition or criteria | |
| Author: Mike Girvin from ExcelisFun | |
| Category: Dynamic Arrays | |
| */ | |
| MEDIANIF = LAMBDA( | |
| CriteriaRange, | |
| CriteriaValue, |