Formulas

Learn how to use functions to write formulas for common tasks like looking up values (VLOOKUP) and summarizing data (SUMIFS).

How to Split Text in Cells Using Formulas

Formulas

How to Split Text in Cells Using Formulas

May 26, 2021

UNIQUE Formula for Non-Adjacent Columns

Formulas

UNIQUE Formula for Non-Adjacent Columns

February 16, 2021

Formulas

Seating Chart Planner – Excel Hash – Episode 3

February 2, 2021

XLOOKUP Go To Source Macro

Formulas, Macros & VBA

Go To Source Cell of XLOOKUP Formula

January 20, 2021

FILTER Non-Adjacent Columns

Formulas

FILTER Formula to Return Non-Adjacent Columns in Any Order

November 11, 2020

3 Ways to Fill Down Blank Cells

Formulas, Macros & VBA

3 Ways to Fill Down Blank Cells in Excel

October 21, 2020

Vlookup to Other Workbooks - Managing & Sharing Files with Formula Links

Formulas

Vlookup to Other Workbooks – Managing, Updating, & Sharing Files with Formula Links

September 30, 2020

Dynamic Array Formulas

Formulas

Distinct Count Report with Dynamic Array Formulas

September 22, 2020

Total Rows for Dynamic Array Formulas and Spill Ranges in Excel

Formulas

Total Rows for Dynamic Array Formulas & Spill Ranges

August 12, 2020