Hello,

If somebody can optimize something that I tried to solve with formulas :(
A macro should be nice and more efficient.

A Loop in column AC for all records from 2 till last.
This column exist of several records with a lot of doubles in it.

It's not a problem to identify them (like CountIf), but...... I had to follow up something which should be related to only the uniques (the 'no' doubles) and the first one of the 'yes' doubles.

Is there an easy way to set in column AD the number "1" if it is the only one (no doubles in the list) or the first one (the first of the doubles) and a zero "0" if a double was earlier in the list and already foreseen with a 1 in column AD


Like

AC AD

AAA 1
BBB 1
AAA 0
CCC 1
DDD 1
AAA 0
EEE 1
EEE 0
AAA 0
FFF 1

Everybody have a nice Easter and not to much eggs :)

Regards, Johan

Hu Johan,

Am Fri, 19 Apr 2019 05:01:34 -0700 (PDT) schrieb :

AC AD

AAA 1
BBB 1
AAA 0
CCC 1
DDD 1
AAA 0
EEE 1
EEE 0
AAA 0
FFF 1

the easiest way is a formula. Try in AD2:
=--(AANTAL.ALS(AC$2:AC2;AC2)=1)
and copy down


Regards
Claus B.
--
Windows10
Office 2016

Sometimes Excell looks really simple.
Claus thanks a lot.

in English formula;
=COUNTIF(AC$2:AC2;AC2)=1 (and then copy down)

Works as requered :)

regards, Johan