CHatmaker

/*  FUNCTION NAME:  Aboutλ
    DESCRIPTION:*//**Displays the URL to this module's Gist which includes documentation*/
/*  REVISIONS:      Date            Developer       Description  
                    Mar 17 2023 Craig Hatmaker  Copyright
                    Apr 17 2023 Craig Hatmaker  Reorganizing and adding help
                    Jul 03 2023 Craig Hatmaker  See nFoldCartProdλ and PriorDimProdλ
                    Jul 11 2023 Craig Hatmaker  See UnPivotDetailλ
                    Feb 11 2024 Craig Hatmaker  See UnPivotDetailλ
*/

ExcelRobot

/*
Name:  Multi-Level Dropdown Validation (MultiLevelDropdownValidation)
Description:  Returns the list of allowable values for a specific cell based on 
   the entries to the left.
Parameters:
   tablename - name of the Excel table containing the data validation dropdowns.
   header - table header cells from the first column with data validation to the column for which
      to return list of values allowed.
   keylisttable - reference to dynamic range containing the MultiLevelKeyLists lambda key lists table.
Source:  Written by Excel Robot, inspired by Wyn Hopkins (https://www.youtube.com/watch?v=r0DTFodQYJQ&t=989s)

ExcelRobot

/*
Name: Choose Table Columns (CHOOSETABLECOLUMNS)
Description: Similar to CHOOSECOLUMNS but can accept an array of column header names or 
   array of column indexes.  If column headers are used, assumes first row of Table is
   header row.
Author: Excel Robot (@ExcelRobot)
Category: Table
*/
CHOOSETABLECOLUMNS = LAMBDA(Table, ColumnsToSelect, LET(
    FirstColumnToSelect, INDEX(ColumnsToSelect,1,1), 

ncalm

/*
LEV

Calculates the Levenshtein distance between two strings

Inputs
	- a: a string to compare with b
	- b: a string to compare with a
	- [ii]: the [ii]th position in string a
	- [jj]: the [jj]th position in string b