This video explains how the dollar sign is used in Excel formulas to control whether cell references stay fixed or change ...
To make the most of the UNIQUE function, you should make sure your array is in an Excel table. By using a table name rather ...