This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

How to count the number of duplicate values in a column

Posted on 06-09-2021 06:04 AM
Emilian_Bem
Silver 1
Silver 1
Reply posted on --/--/---- --:-- AM

How to count the number of repeated values in a column? I searched many threads but unfortunately did not find a clear answer.

Thank you for your time!

Solved Solved
0 2 749
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
Reply posted on --/--/---- --:-- AM

Maybe this:

(COUNT(table[column]) - COUNT(UNIQUE(table[column])))

View solution in original post

Jump to Solution
2 REPLIES 2

Posted on --/--/---- --:-- AM
Suvrutt_Gurjar
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM

Could you please elaborate your requirement with some examples?

Jump to Solution

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
Reply posted on --/--/---- --:-- AM

Maybe this:

(COUNT(table[column]) - COUNT(UNIQUE(table[column])))
Jump to Solution
Top Labels in this Space