IFERROR(IFERROR(COUNTIF(COUNTIF Syntax error

rsheehan

I may just be missing the logic but I am looking to check two sheets for duplicates within a sheet. I keep getting a syntax error when writing the following;

=IFERROR(IFERROR(COUNTIF(Address:Address, Address@row)>1,1,0,(COUNTIF({Con. Install. Track Arch Address}:{Con. Install. Track Arch Address},Address@row)>1,1,0)),0)

Paul Newcome

The COUNTIF statements won't throw any errors unless you have an error in one of the referenced ranges. They would just output a zero if no match is found. Try this instead:

=IF(COUNTIF(Address:Address, Address@row) + COUNTIF({Con. Install. Track Arch Address},Address@row)> 1, 1)