Need to compare two excel sheet columns please suggest me a source.
I need compare 1 and 2 expressions indicated with yellow
Green one which didnt worked.
Individually we are getting the values but, here we need to compare both sheets . I have indicated with red arrow in below image . Which columns need to compare.
Sample file:
sample.zip (9.9 KB)
Have you searched the forum? There are a ton of posts on comparing sheets etc
The thing here is how to write logic for comparing those specific columns. we have tried but didnt worked
Hello @Soundarya_Guduri
What the purpose of compare the data, do you need to remove the data which not contains sheet 2 data on sheet 1?
Brief your comparing purpose.
Once comparison is done based on postal code (eg:2620) that particular value need to fetch shown in image with red arrow and store in separate variable.
Hey
Can you explain better what you need, pelase?
For each value on Column A on the Sheet2 you need to check if the value exist on the Sheet1? And if it exists? And if it doesnt exist? You want to compare exactly or you want to check only if the LastAddress on Sheet1 “Contains” the value?
For each value on Column A on the Sheet2 you need to check if the value exist on the Sheet1? And if it exists?
Need to fetch the value
And if it doesnt exist?
Nothing to do or we can put log message .
You want to compare exactly or you want to check only if the LastAddress on Sheet1 “Contains” the value?
Yes need to compare lastAddress text with sheet2 column A data as shown in image .
Anil_G
Yoichi
Chirag_Shetty_Divakar
fernando_zuluaga
Jithesh_R
loi.nguyen
Samraat_Maharjan1
prabin_chand1
supermanPunch
supriya117