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
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Show or hide item (or items) in PivotTable for a certain field. Passing ...
Jan23
Have custom profile link to your LinkedIn profile If you are in tech for a ...
2019Jan16