Array Function 1 (UNIQUE, SORT, TRANSPOSE, FILTER)
An array function in Excel is a function that can perform multiple calculations on one or more sets of values (arrays) and return either a single result or multiple results. Arrays are used to hold a collection of data, which can be used in functions to perform operations like summing, averaging, or multiplying corresponding elements.
Workbook: https://rty3-my.sharepoint.com/:x:/g/...