The Excel UNIQUE function returns a list of unique values in a list or range. Values can be text, numbers, dates, times, etc. Extract unique values from range Return value Array of unique values Syntax =UNIQUE (array, [by_col], [exactly_once])Arguments array – Range or array from which to extract unique values. by_col – [optional] How to compare and extract. By Read More