Rick teleksterling

teleksterling / Utils.txt

Last active May 4, 2024 07:38

Excel Lambda Utility Functions (Excel Labs / Advanced Formula Environment)

	Header = LAMBDA(Table, TAKE(Table, 1));

	Data = LAMBDA(Table, DROP(Table, 1));

	ConstArray = LAMBDA(value, rows, columns,
	EXPAND(value, rows, columns, value)
	);

	Reverse = LAMBDA(array,
	LET(seq, SEQUENCE(ROWS(array)), SORTBY(array, seq, -1))

teleksterling / EnvPaths.psm1

Created June 5, 2023 01:06 — forked from mkropat/EnvPaths.psm1

	function Add-EnvPath {
	param(
	[Parameter(Mandatory=$true)]
	[string] $Path,

	[ValidateSet('Machine', 'User', 'Session')]
	[string] $Container = 'Session'
	)

	if ($Container -ne 'Session') {