Determine if column contains duplicate value
 

Is there a way to determine if a column range contains a duplicate value
with a formula in one cell? The formula would return 1 if there are no
repeating values and 0 if a value is found more than once.

Determine if column contains duplicate value
 

It's possible.

Here are the formulae:

http://www.cpearson.com/excel/Duplicates.aspx


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"ABM" wrote:

Is there a way to determine if a column range contains a duplicate value
with a formula in one cell? The formula would return 1 if there are no
repeating values and 0 if a value is found more than once.