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...
Count Unique
A question by a colleague on how to count number of unique items in a column made me realize, I don't have that here.
So here...
SimpleANBox
This is a financial box, a saving account, a credit, a loan, or any other financial amount that has input and output. During my time...
Compare2, a tool to compare two sheets using formulas
Tool will compare between two sheets using formula/functions method. Once you type in full folder locations (for both files), file names and sheets names in...
BMI Calculator
A simple calculator, how come we do not have one like this?...
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...
IF with AND and IF with OR
The powerful function If can already do a lot of tricks, but we can for sure do more when we use it with AND or...