Do the opposite of this formula:

[Guest]

I have found this formula:

=IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1)

here:

http://support.microsoft.com/kb/213367/en-us

It basically looks at 2 columns of data, and shows the duplicates in column B.

I want to show the unique entries rather than the duplicates.

Can anyone help?

Thanks!

 

[Guest]

Select your coumn in this case A1 - A100 then

format|conditional format|formula is

paste this in ad pick a colour to highlight unique entries in the range

=COUNTIF($A$1:$A$100,A1)=1

Mike

 

[Guest]

I ended up doing this:

=IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),A1,"")

 

[Dave Peterson]

Another way is to use:

=IF(ISnumber(MATCH(A1,$C$1:$C$5,0)),"",A1)