Cimpter $1$ Culz$-(21$SP$-$Fuli$)$ BU

httpse$//$rumwebassignnet$/$web$/$Student$/$Assignment$-$Responses$/$last$?$dep$=33416323$

Camas

Business Pathwoys L$..$

General $($OoP Stu As$.$

Marketing Research.

Mail $-$ Stringer, Chio.

$[-]$ The UNIQUE function

You can find more information about the UNIQUE function at Office Support. 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$].$ 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$.$ matches the results of the UNIQUE function?

Soylent Corp

Nakatomi Corp

Massive Dynamic

Stark Industries

Acme Corporation

Umbrella Corporation

Vehement Capital Partners

Globex Corporation

Initech

Initech

Soylent Corp

Nakatomi Corp

Stark Industries

Massive Dynamic

Acme Corporation

Globex Corporation

Umbrella Corporation

Vehement Capital Partners

Initech

Globex Corporation

Vehement Capital Partners

Umbrella Corporation

Acme Corporation

Stark Industries

Massive Dynamic

Nakatomi Corp

Soylent Corp added to the Company column, the list in E$2$ will update to reflect the new company and spill into one additional cell.

THE SORT function

Dynamic Array errors

Referencing Dynamic Arrays