Generate a random GUID using oracle db workbench Also add timestamp to ensure ...
2019Dec22
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
Sets Autofilter in a sheet, and another function to clear Autofilter ...
2020Jan3
Gets list of years and total of posts per year from a table, by using date ...
2018Jul29
Returns random IDs (or any column) from SQL Database table, passing number of ...
2018Jul29
Reset numbers in ID column, with help from AI. The StoredProcedure will move ...
Dec17
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...
2021May29