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, |
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, |
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: VARIANCE | |
Description: Variance | |
Author: Carlos Barboza (inspired from a post on this formula by Mike Alexander aka DataPig) | |
Category: Formula | |
*/ | |
VARIANCE = LAMBDA( | |
ThisYear, | |
PriorYear, |