Thread: Compare columns remove duplicates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Compare columns remove duplicates
Create a helper column
C2 =COUNTIF($B$2:$B$100,A2)
copy as far as needed
AutoFilter all the 1s (which are duplicates), then delete

"Tommy Geek" wrote:

How might I compare 2 columns (A,B) on an excel worksheet and remove
duplicates from column A?
Reply With QuoteReply With Quote