Duplicates True/False with errors

pto160

Active Member
Joined
Feb 1, 2009
Messages
303
Office Version
365
Platform
Windows
I have a formula that identifies if there is duplicates in a column.

=MAX(COUNTIF(B1:B30,B1:B30)*(B1:B30<>""))>1

How would I add a condition to exclude errors like #N/A in a column?
 

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
7,817
Office Version
365
Platform
Windows
Same formula with an IFERROR should sort it out.

=MAX(COUNTIF(B1:B30,B1:B30)*(IFERROR(B1:B30<>"",0)))>1

Enter CNTL-SHIFT-ENTER.
 

pto160

Active Member
Joined
Feb 1, 2009
Messages
303
Office Version
365
Platform
Windows
Thank you so much. It works great.
 

Forum statistics

Threads
1,084,913
Messages
5,380,548
Members
401,688
Latest member
Empa

Some videos you may like

This Week's Hot Topics

Top