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
Adjust iframe height to its content after loading page Needed this trick in ...
2023Apr29
Bootstrap checkbox with font-awesome (BS-FA Checkbox)
From
2019Jul30
Issue: Trying to copy file (Using VB command FileCopy) while that file was ...
2018Sep26