Selecting of Unique, Non-Unique or Distinct numbers from a source series

0

Hi all!
QM20.1.0 has received new Distinct() function. Now it has become much easier to extract different types of samples from the data source: Unique, Non-Unique or Distinct numbers (see below). To do this, you need to use only one auxiliary Item: UnqFlag. For the convenience of information perception, different types of samples are sorted ascending by the Small() function. Who prefers sorting in descending order, replace Small() in the formulas with Large().

Answered question
0

*

*

*
As you can see, Unique numbers do not have duplicates; Non-Unique numbers must have duplicates; Distinct numbers is a Union of Unique numbers with Non-Unique numbers.
*
Good luck

Answered question