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

1

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().

S A U Answered question March 2, 2020
1

*

*

*
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

S A U Answered question March 2, 2020

Latest Questions