Sets Autofilter in a sheet, and another function to clear Autofilter ...
2020Jan3
Create list of unique items from a column into another column This is similar ...
2022Apr26
Removes duplicated items from a 1-dim array into new array, does not modify ...
2022Jul7
Returns sum of certain column in range (or table) in sheet after applying ...
2021Jan29
Creates "Update Table " SQL statements to be executed inside SQL to modify ...
2022Jul4
Give users ability to multi-select from list of items into cells with separator. ...
2021Jun23
Quickly adds value to certain column in Excel sheet As usual, you can define ...
2020Jan3
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
Shorten a long Dir by adding ... in the middle to make it fit in small boxes ...
2020Feb19
Creates youtube embed from link Converts a youtube video link into a youtube ...
2019Dec31
jQuery Ajax File Uploader Widget Promising, need to start implementing it in ...
2019Jun28
Simple small function to Encrypt or Decrypt a string in cell Simple Encryption ...
2018Jun14