Category: Formulas – combined functions

Two or more functions = One Formula, how to combine more than one function to present a powerful formula that does the job well

Looplist – Repeating months using formulas

Scorring, saving multiple outputs in 1 number

Compare2, a tool to compare two sheets using formulas

Skills Grid

IFS (and IFNA) to avoid nested IFs

Limited Ceiling

Count cells with condition – multiple conditions

IF with AND and IF with OR

OFFSET+MATCH

Count how many times letter found

Multiple lines in cell using functions