Skip to content

Instantly share code, notes, and snippets.

@RecalcOrDie
Created May 4, 2022 00:32
Show Gist options
  • Save RecalcOrDie/3ae7d4e993afbea57e68348de302b2d2 to your computer and use it in GitHub Desktop.
Save RecalcOrDie/3ae7d4e993afbea57e68348de302b2d2 to your computer and use it in GitHub Desktop.
LAMBDA used to get MEDIANIF
/*
Name: MEDIANIFλ
Description: LAMBDA used to get MEDIANIF
Author: Peter Bartholomew
Category: Dynamic Arrays
*/
MEDIANIFλ = LAMBDA(
CriteriaRange,
CriteriaValues,
ValuesRange,
MAP( CriteriaValues,
LAMBDA( CriteriaValue,
MEDIAN( IF( CriteriaRange = CriteriaValue, ValuesRange ) )
)
)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment