i have excel sheet , i want to compare two columns(A,B) in same sheet. if both matched and not matched write into separate sheet . how can do it
can anyone help this ?
Please use the below method to compare two columns.
After this use write range to write the output in another sheet.
Feel free to reach us at any time if you have doubts. Thanks.
it is not working filter… getting same old data.
You are getting the whole values? I can’t understand what you are meaning.
I have attached the below screen shot for your reference.
thank you @vignesh.ks before it come unfilter data. now its working fine.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.