Shows or hides an item or items in a PivotTable filter field. Passing ...
Finds how many a string found inside larger string. Similar to Frequency but ...
Return a range of cells in column where ... Return Range Ignore header ...
Runs SQL Command that needs no return This is primarily useful for CREATE, ...
Filter table inside Excel the fast way (using advanced filter) into another ...
Quickly adds value to certain column in Excel sheet As usual, you can define ...
Sets an attribute to file or folder Needs to have variables defined as you see ...
Applies format into a cell (or range) from another cell. Can apply from any ...
Cuts a string from a string FROM RIGHT starting from specific character and ...
50 chars max.