Do the opposite of this formula:
 

I have found this formula:

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

he

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!

Do the opposite of this formula:
 

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

"Dave" wrote:

I have found this formula:

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

he

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!

Do the opposite of this formula:
 

I ended up doing this:

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

"Mike H" wrote:

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

"Dave" wrote:

I have found this formula:

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

he

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!

Do the opposite of this formula:
 

Another way is to use:

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



Dave wrote:

I have found this formula:

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

he

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!

--

Dave Peterson