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 UNIQUE that can do that.

TIP: If you want to reference an individual column in a data table the syntax is: TableName$[$ColumnName$].$ For example, to reference the Company column in Table$1$ it would be Table$1[$Company$].$

In column A$,$ you will find a long list of company names in Table$1.$ To obtain a list containing each unique company, navigate to cell E$2$ and enter $=$UNIQUE to pull up the UNIQUE function. This function takes three arguments: $=$UNIQUE$($Array$,[$By$\_$Column$],[$Occurs$\_$Once$]).$ The first argument, array, is where the data is located, and the last two arguments are TRUE$/$FALSE$.$

In cell E$2,$ use the UNIQUE function to reference the Company column in Table$1$ for the first argument $($array$)$ and then make the last two arguments both FALSE. Which list below matches the results of the UNIQUE function? Select the correct list.

I. Globex Corporation II$.$ Nakatomi Corp III. Stark Industries