Prev: UNREADABLE CONTENT
Next: function Making one row out of many
From: BeckyB on 30 Mar 2010 11:18
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
From: Chip Pearson on 30 Mar 2010 11:30
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
<BeckyB(a)discussions.microsoft.com> 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
 | 
Pages: 1
Prev: UNREADABLE CONTENT
Next: function Making one row out of many