NOTE: When this problem was authored, Dynamic Array Functions were still very new to Excel. They are currently available in Excel Online as well as up to date desktop versions of Office $365$ for Windows and Mac. This problem utilizes Excel Online to ensure these functions are available.

In past versions of Excel, the program had what were called "array functions." The easiest way to understand what these functions did is to picture them as one input cell that generated output that spanned $($or "spilled into"$)$ multiple cells. While powerful, they were difficult to use and required specialized keystrokes to implement. To make array functions easier to use, Microsoft recently created Dynamic Array Functions in Excel which eliminated the cumbersome implementation of the older array functions.

Dynamic Array Functions can be extremely useful in business applications. Additionally, when combined, they can create flexible dynamic tables and dashboards that allow a user to get insights from data quickly. The most important word to consider is "dynamic" in that the results of these functions can change depending on other data in spreadsheet. Let's use this graded tutorial and the accompanying spreadsheet to see how they work.

The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

Open spreadsheet

The UNIQUE function

You can find more information about the UNIQUE function at Office Support here.

Oftentimes we have a long list of repeating data; company names, customer names, states, email addresses, etc. and we would like a simple list of all the unique items in the data. Luckily, Microsoft created a new dynamic array function named