Hi

 

I try to select names wich are displayed only one time.

So I use a formula for duplicates like this one :

 

let myV := 'Bird name';

if cnt(select 'table name' where 'Bird name' = myV) > 1 then

"Duplicate"

else

"no duplicate"

end

 

But that displays the duplicates one time but not the names that are alone.

 

If I have 3 Aras :

Ara vert

Ara rouge

Ara bleu

It will display "Ara" one time, good !

 

But if I have

Amazon

Eagle

> only one Amazon and only one Eagle they will not be displayed because there is no duplicates of Amazon neither Eagle.

 

With Excel app

if I use

=SI(NB.SI($G$2:G2;G2)>1;"Doublon";"")

 

That works : the duplicates name are displayed one time AND the names alone are also displayed one time.

 

I show that Excel formula because that maybe could help someone would like to adapt it to the Ninox formula.

 

Thanks