Excel 2020: Formula for Unique or Distinct
September 21, 2020 - by Bill Jelen
The UNIQUE function will provide either a list of unique or distinct values.
If you ask me for the list of unique values from this list: Apple, Apple, Banana, Cherry, Cherry, I would tell you that the list of unique values is Apple, Banana, Cherry. If you ask 100 accountants, about 92 of them would agree with me. But there is a segment of the population who disagrees and says that the only unique thing in the list is Banana because it is the only item that appears once.