Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...
2021Sep21
Converts a string of items into range, with custom separator.
Opposite of
2022Nov11
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
Adds an amount (or subtract) from a range of cells in one click
Similar to
2023Feb18
Concatenate all rows found in a range starting A1Cell for Columns_To columns ...
2023Mar6
Adds databars conditional formatting to range of cells. Passing column, start ...
2022Aug22
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
Apply validation on two cells, when a 3rd cell is changed When modifying a ...
2020May27
Bootstrap date range picker
From
2019Jul31
Disables or Enables certain Excel built-in shortcut. Code has example on how ...
2018Aug16