Mearns Learns

Formula

• Checkboxes in cells
• CONCAT
• Copy Formulas without changing the cell references
• Data comparison take 1
• Data comparison take 2
• Data comparison take 3
• DAYS
• FORMULATEXT
• IFNA
• IFS
• ISFORMULA
• MAXIFS and MINIFS
• NUMBERVALUE
• Quickly highlight unique or duplicate values
• SHEET
• SWITCH
• TEXTJOIN
• Two way lookups
• VSTACK