Home

Dublicates counter

%3CLINGO-SUB%20id%3D%22lingo-sub-826182%22%20slang%3D%22en-US%22%3EDublicates%20counter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826182%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20what%20I%20am%20trying%20to%20build%20is%20a%20formular%20which%20generates%20for%20every%20number%20the%20value%201%20except%20the%20number%20appears%20more%20than%20one%20time.%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20Number%20appears%20more%20than%20one%20time%20the%20system%20should%20count%20the%20dublicates%20until%20a%20new%20number%20appears.%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20find%20the%20table%20below.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E101%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E101%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E102%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E103%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E104%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E104%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E105%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E106%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E106%3C%2FTD%3E%3CTD%3E2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E106%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E107%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-826182%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E1602%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826284%22%20slang%3D%22en-US%22%3ERe%3A%20Dublicates%20counter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826284%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F393336%22%20target%3D%22_blank%22%3E%40ATSV1900%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAssuming%20your%20numbers%20are%20in%20column%20A%20starting%20from%20A1%2C%20put%20in%20B1%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DCOUNTIF(%24A%241%3A%24A1%2CA1)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Eand%20drag%20it%20down%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
ATSV1900
Occasional Visitor

Hello all, 

 

So what I am trying to build is a formular which generates for every number the value 1 except the number appears more than one time. 

If the Number appears more than one time the system should count the dublicates until a new number appears. 

Please find the table below. 

 

1011
1012
1021
1031
1041
1042
1051
1061
1062
1063
1071

 

 

 

1 Reply

@ATSV1900 

Assuming your numbers are in column A starting from A1, put in B1

=COUNTIF($A$1:$A1,A1)

and drag it down

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies