MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Duplicated Numbers In A Column


Posted by Stephen Hoadley on January 25, 2002 1:09 AM

Is it possible to look at a column of numbers to see if any numbers are duplicated I only need a yes or no in my answer I dont need to know what numbers are duplicated


Posted by Aladin Akyurek on January 25, 2002 2:01 AM

Lets say that the range of numbers of interest is A2:A300.

=(COUNT(A2:A300)-SUM(IF(FREQUENCY(A2:A300,A2:A300)>0,1))>0)+0

will result either in 1 if one or more numbers in A2:A300 have duplicates or in 0 if none is duplicated.

Posted by Stephen Hoadley on January 25, 2002 2:46 AM

Thanks Just What I Wanted