Selecting of Unique, Non-Unique or Distinct numbers from a source series
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