Thread: Do the opposite of this formula:
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default 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!
Reply With QuoteReply With Quote