Thread: Delete BOTH sets duplicate data in columns (debits/credits)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Iamconstance Iamconstance is offline
external usenet poster
  
Posts: 1
Default Delete BOTH sets duplicate data in columns (debits/credits)
I am trying to find out how to delete BOTH sets of data in a column when
there is not a unique entry. For example if I have a 10 in cell A1 and a 10
in cell B5 I would like them BOTH to be removed, leaving me with only values
in Cell A that have no match anywhere in Cell B. Is this possible?
Reply With QuoteReply With Quote