Thread: Question... Marking the unique- and the first one of the doubles with1 or 0 in the column next
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Question... Marking the unique- and the first one of the doubles with 1 or 0 in the column next
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
Reply With QuoteReply With Quote