MM0016 - 16/03/20 - Trying Out New Excel Formulae

Let's look at some of the new Excel 'array' formulae and consider their pros and cons compared to Excel VBA

Topics

  •  | Bart - Homework Review
  •  | 1004 - Application-defined Error
  •  | Variables - Error Caused By Wrong Type
  •  | Breakpoint Example
  •  | Jazfin - Homework Review
  •  | Discussion Of Direct Vs. Remote Referencing
  •  | IF Statement - IF - END IF
  •  | Discussion Of Array Formulae New In 2020
  •  | Remove Duplicates From Dataset
  •  | UNIQUE
  •  | SORT
  •  | Macro To List Unique Values
  •  | Application.WorksheetFunction.COUNTIF
  •  | Discussion: VBA Vs. UNIQUE Formula
1 Lesson