Lesson learned: Do not trust Google Sheets function
It wasted few days, hitting my head at the wall.My mistake …. I trusted that Google Sheets function called GoogleTranslate is working as it is...
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/...
GoLast to jump to last cell in a column
Edit 2021-07-12: I needed this formula to work in a worksheet having space in its name, so original one did not work, here is the...
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...