Results 1 to 3 of 3

Thread: Need a formula to count the count of duplicate values

  1. #1

    Post Need a formula to count the count of duplicate values



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello Friends,

    Can somebody help me with the excel formula to get the count of Duplicate values in a list. I don't need the number time the duplicate values are appearing in a list. Need to know how duplicate values are duplicate.

    Thanks....!!

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,821
    Articles
    0
    Excel Version
    O365
    Do you want to try that one again?

  3. #3
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    The easiest way is to first add a helper column to find those duplicates.

    =COUNTIF($A$2:$A2,$A2)=2

    copied down. As soon as a second is found, it is marked.

    Then separately to get count of duplicates =COUNTIF(B:B,TRUE)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •