Generate a random GUID using oracle db workbench Also add timestamp to ensure ...
2019Dec22
Creates list of items found in rows, where these rows match a value in another ...
2020May13
Quickly adds value to certain column in Excel sheet As usual, you can define ...
2020Jan3
Gets most recent N files from a given folder. Uses Arrays, and the function ...
2018Oct1
Reads from a table in a DB Reads only the first row, and return a string ...
2018Apr21
Creates list of unique items found in a column, returns string with items ...
2020May6
Returns list of rows numbers having cells matching text in a column. Passing ...
2021Dec27
Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...
2018Jun30
Counts how many cells matching 2 criterias.
Just like
May1
Listing the file from a folder that was created during last few hours. Can ...
Apr30
Exports range to an image, something we wanted to be able to do for a while now. ...
2022Feb16
Simple Date stamp, calendar, day view whatever you call it. was looking for ...
2021Jun27