View Single Post
  #2   Report Post  
wickedchew wickedchew is offline
Senior Member
 
Location: Philippines
Posts: 161
Default

Quote:
Originally Posted by nackgr View Post
I have the excel bellow at zip file

I want a solution that Search collum A and B and delete the dublicate entrys ( If number is at collum A and B delete it )
Why not combine the data in Column B with Column A then use:

=COUNTIF(A:A,A1)
__________________
Asobi Wa Owari Da