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
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
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
Random Codes
ANSQLWherein
Creates list of items to be used in ' Where item in (List)' list Mainly adds ...
2020Jan6
More Bootstrap wells
Additional Bootstrap well colors, I always find it easier to use Wells (used in ...
2019Jun28
Porting Excel/VBA into OpenOffice Calc
PDF document on what needed to import VBA from Excel into OpenOffice Calc Basic
2019Feb8