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.