Question... Marking the unique- and the first one of the doubleswith 1 or 0 in the column next
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
|