YeeBePrime
YeeBePrime
/ excel-lambda-getAddressByValue.txt
Created
November 12, 2022 01:36
To get the address of specified value in range.
This file contains hidden or 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
| /* | |
| getAddressByValue | |
| To get value address in range. | |
| Syntax | |
| =getAddressByValue (_value,range) | |
| The getAddressByValue function syntax has the following arguments: |
YeeBePrime
/ excel-lambda-uniqueCols.txt
Created
November 4, 2022 02:03
Returns unique values in column by column of range
This file contains hidden or 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
| /* | |
| uniqueCols | |
| Description | |
| Returns unique values in column by column of range | |
| Syntax | |
| uniqueCols(datarange,[by_col],[exactly_once],[lastresult],[lastcol]) | |
| The uniqueCols function syntax has the following arguments: |
YeeBePrime
/ excel-lambda-getDateByWknum.txt
Created
October 25, 2022 23:48
To get date by weeknum and other options, dayname, year, return_type.
This file contains hidden or 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
| /* | |
| getDateByWknum | |
| Description | |
| To get date by weeknum and other options. | |
| Syntax | |
| getDateByWkNum(weeknumber,[dayname],[year],[return_type]) | |
| The getDateByWkNum function syntax has the following arguments: |
YeeBePrime
/ excel-lambda-textSplitA.txt
Last active
June 15, 2023 14:56
Splits text strings by using column delimiters. Support 1 dimension array.
This file contains hidden or 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
| /* | |
| textSplitA | |
| Splits text strings by using column delimiters. Support 1 dimension array. | |
| The textSplitA function works LIKE the built-in TEXTSPLIT function but support 1 dimension text array/range | |
| Syntax | |
| =textSplitA (range,col_delimiter,[row_delimiter]) |
YeeBePrime
/ excel-lambda-reverseText.txt
Last active
June 15, 2023 14:56
To get reverse text characters.
This file contains hidden or 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
| /* | |
| reverseText | |
| Description | |
| To get reverse text characters. | |
| Syntax | |
| reverseText(datarange) | |
| The reverseText function syntax has the following arguments: |
YeeBePrime
/ excel-lambda-extractNumberFromText.txt
Created
October 18, 2022 00:37
To extract number or letter from specified text.
This file contains hidden or 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
| /* | |
| extractNumberFromText | |
| Description | |
| To extract number or letter from specified text. | |
| Syntax | |
| extractNumberFromText(Text, [number]) | |
| The extractNumberFromText function syntax has the following arguments: |
YeeBePrime
/ excel-lambda-removeDupToBlank.txt
Created
October 17, 2022 11:27
Remove the follow duplicated items in column and replace with blank.
This file contains hidden or 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
| /* | |
| removeDupToBlank | |
| Description | |
| Remove the follow duplicated items in column and replace with blank. | |
| Syntax | |
| removeDupToBlank (datarange, [last_result], [lastrow], [last_val]) | |
| The removeDupToBlank function syntax has the following arguments: |
This file contains hidden or 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
| /* | |
| delCnt | |
| Description | |
| To count delimiters in Text. | |
| Syntax | |
| delCnt(text, delimiter) | |
| The delCnt function syntax has the following arguments: |
YeeBePrime
/ excel-lambda-countIFArr.txt
Last active
February 18, 2024 09:45
CountIF function that can be used with array/range using Excel lambda function.
This file contains hidden or 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
| /* | |
| countIFArr | |
| Description | |
| CountIF that can be used with array/range. | |
| Syntax | |
| countIFArr(ArraytoLook, LookFor) | |
| The countIFArr function syntax has the following arguments: |
YeeBePrime
/ excel-lambda-customSORT.txt
Created
September 30, 2022 04:57
To Sort item range by custom sort setting using Excel lambda function
This file contains hidden or 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
| /* | |
| customSORT | |
| Description | |
| Sort item range by custom sort setting. | |
| Syntax | |
| customSORT(Range, setSort) | |
| The customSORT function syntax has the following arguments: |
NewerOlder