Hi

The entire data set is unique so it will bring back all records.

Or do you only want the unique entries from column A? If so, then only select column A for your data range, nothing in the criteria, nominate the output cell, and select unique.

rylo