Sets Autofilter in a sheet, and another function to clear Autofilter ...
2020Jan3
Returns sum of certain column in range (or table) in sheet after applying ...
2021Jan29
Clears all filters in PivotTable and hide the [blank] item from list, pass ...
Dec22
Removes duplicated items from a 1-dim array into new array, does not modify ...
2022Jul7
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
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
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23