Similar codes
Random GUID
Generate a random GUID using oracle db workbench Also add timestamp to ensure ...
2019Dec22
CreateList_Matching
Creates list of items found in rows, where these rows match a value in another ...
2020May13
Add2Column
Quickly adds value to certain column in Excel sheet As usual, you can define ...
2020Jan3
Files_MostRecentN
Gets most recent N files from a given folder. Uses Arrays, and the function ...
2018Oct1
DB_Read1Row (DB_Read1stRow)
Reads from a table in a DB Reads only the first row, and return a string ...
2018Apr21
Column2AnString_Unique
Creates list of unique items found in a column, returns string with items ...
2020May6
RowList_Matching
Returns list of rows numbers having cells matching text in a column. Passing ...
2021Dec27
FormulasFlatten
Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...
2018Jun30
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
SendEmailMsgv2023
Sending email using Microsoft 365 account. Edit 2024-01-02: Adding ability to ...
Nov12
ApplyValidation_DropDown
Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...
2018Aug10
Base64encode + Base64decode
Encodes and decodes a string, Base64 is used to convert binary data (like ...
2018Jul31
FS_CreateUserFolder
Creates a folder for a user, usually after sign up or login for first time
2018Jul9