Category: Lookup and References

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...

Skills Grid

A small Excel file to show how we can create a chart-like Excel sheet Used in my Resume to show different skill sets and the...

Sheet() and Sheets()

Getting total number of sheets (Sheets), or ID of this sheet (Sheet). The two new formulas Sheet() and Sheets() can do well, yes not perfect,...

FORMULATEXT to show formulas

Back in the day, we used to need to write a full macro (also called User-Defined-Function) to allow users to show the formula from a...

New function IFERROR, finally

We have already gotten used to use VLOOKUP, MATCH and other functions that generates errors inside an IF But, we do not need that anymore...