Searching for an item in a column from bottom to top. Will search for item in ...
Apr8
Returns column if an item from list of items was found in a row. Similar to ...
Oct30
Searches for an item in a column, then if found, delete that cell (not clear, ...
2018Jun17
The best Match I created, return 0 if not found, kind of CountIF+Match ...
2018Jun16
The best Match I created, return 0 if not found, kind of CountIF+Match ...
2018Jun16
Swap two numbers variables without using third variable A trick worth saving ...
2022Oct17
Finds location of 1st numeric character inside string starting from a certain ...
Feb25
Returns column if an item from list of items was found in a row. Similar to ...
Oct30
Finds 3 numbers in a string by ignoring characters between them. ' example ...
Mar2
Counts how many cells in a column in any sheet, any workbook using COUNTIF ...
2018May23
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
Good slide view, animated moving menu, or wizard steps
From
2019Jul4
Disables or Enables certain Excel built-in shortcut. Code has example on how ...
2018Aug16
Closes a workbook, checks if it is already open first, works for workbooks ...
2018Aug9