Count Duplicate Values in a range


Excel Course : The Ultimate Excel Programmer Course

Suppose you want to count cells that have duplicate values.

Assuming data is entered in range A2:A10.

Paste the following formula in cell B2
=SUMPRODUCT(--(COUNTIF(A2:A10,A2:A10)>1))
Coursera Data Science

Excel Tutorials : 100 Excel Tutorials

Get Free Email Updates :
*Please confirm your email address by clicking on the link sent to your Email*

Related Posts:

1 Response to "Count Duplicate Values in a range"

  1. Very helpful formula. Thank you.

    ReplyDelete

Next → ← Prev