Distinct Range
This function produces a distinct list of values from a row or column of data (depending on the Apply To Direction setting).
Note that the list is determined from the content seen in the cell which means that if the values are numeric and formatted to a fixed number of decimal places, multiple values could be considered the same number (even though their decimal value is different).
Settings | |
|---|---|
Case Sensitive | If the values are textual, this determines if case is considered. |
Example
A daily alarm report shows every alarm that occurred over the day. A list of distinct alarms targets focus on what needs attention.
Result
 |
Settings
