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