Count Duplicates

To count cells that have duplicate values

{=SUM(IF(COUNTIF(A1:A10,A1:A10)>1,1,0))}

Push Ctrl, Shift and Enter to make this an array formula



© Copyright andrewsexceltips.net All Rights Reserved.