|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Detect Duplicates
thank you
--
jake
"Max" wrote:
Try this, array-entered (press CTRL+SHIFT+ENTER to confirm the formula):
=IF(MAX(COUNTIF(B11:B97,B11:B97))1,1,0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jakobshavn Isbrae" wrote:
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.
--
jake
|