Hi Senthil
I think you can use the formual --Vlookup(),for example,columns A have 1,2,3,4,5,columns B have 1,2,3.in columns C.C1=vlookup($a1,$b$1:$b$3,1,0),then columns B' data will be match columns A, if not match,will be have a error symbol#N/A,The
error symbol means columns A' data not present in Columns B',so you can filter columns B' error symbol,columns B' error symbol means you want to get the value in columns A.
I hope it can be help you.

penghui.