View Single Post
  #1   Report Post  
vikasarora07
 
Posts: n/a
Default how do i find out what is uncommon in column list A1: A10 and B1:.

i want to compare data in list 1 in column A with list 2 in column B and make
a column C which shows data which is not in A

A B C
apple apple cat
cat ball rubber
ball dog
rubber
dog