What are the Excel Dynamic Arrays In Office 365 | The Power of Dynamic Array Functions | learn xtra




About this tutorial:

Video duration: 00:16:38
Hello Everyone,
Welcome to Learn Xtra 😍

What are Dynamic Array Functions in Excel?

DYNAMIC ARRAY FUNCTIONS
The dynamic array allows formulas to return multiple results to a range of cells on the worksheet based on a single formula entered in one cell.
This behavior is called “spilling” and results appear in a “spill range”.
All results are dynamic – if source content changes, the results dynamically update to stay in sync.

UNIQUE FUNCTION

The Excel UNIQUE function can extract a list of distinct values, or a list of values that only occur once, i.e. unique values.

Arguments of…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads