Detect Duplicates

[Jakobshavn Isbrae]

I have a list of values in B11 down to B97. The values are either numbers or
text, but there are no empty cells in the list. Is there a formula that will
give me 0 if all the values are unique and give me 1 if any of the values are
duplicated?

Thanks in advance for any help.

 

[Fuzzy]

yup...arrange the column is ascending/descending order..
then in column C, apply this formula
=B11=B12..... Drag this to the entire column.. if two subsequent rows are
the same, it returns -true, else if all are unique, it would return false

 

[Max]

Try this, array-entered (press CTRL+SHIFT+ENTER to confirm the formula):
=IF(MAX(COUNTIF(B11:B97,B11:B97))>1,1,0)

 

[ryguy7272]

This is a great resource that may give you more ideas about working with
dupes in Excel:
http://www.cpearson.com/excel/Duplicates.aspx

Regards,
Ryan---

 

[Jakobshavn Isbrae]

thank you
--
jake

Try this, array-entered (press CTRL+SHIFT+ENTER to confirm the formula):
=IF(MAX(COUNTIF(B11:B97,B11:B97))>1,1,0)

 

[Max]

Welcome, Jake