Year: 2020

CTRL+Y a mini macro

On your daily work, in Excel, you have had the need to redo actions, simple same action to multiple areas perhaps Or apply similar format...

Formula Beautifier

Formula Beautifier http://excelformulabeautifier.com/...

CountIf limitation

CountIF function cannot search for text longer than 255 chars. This is mainly found here … https://support.office.com/en-us/article/COUNTIF-function-E0DE10C6-F885-4E71-ABB4-1F464816DF34...

CHOOSE – tree of decisions

If you are like me, then you must have needed to use CHOOSE functionThis is basically like “SELECT CASE” statement, but more limited So, in...

Blank (isempty) VS “” (null string)

If formula results in “”, then that cell will not be empty.When copy and paste as values, it will not be empty either.VersusWhen we use...