Use a custom function like

=IF(ISNA(A1),FALSE,COUNTIF($A$1:$A$10,A1)1)

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com




On Tue, 30 Mar 2010 08:18:02 -0700, BeckyB
wrote:

I am trying to do a conditional format formula to highlight duplicate
results, but I have #n/a on some. Is there a way to write the formula to find
all duplicates in 1 column, but ignore all #n/a values too?

Thanks,
BeckyB