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!