I have a set of data that I would like to compare and analyze to find similarities. The data is in an Excel file and I dont know if one can write an excel script or macro to do the job or any other way. See the attached document. There are 2 sheets in the document, SHEET1 and SHEET2 and it is these datas I would like to compare and analyze.
As you see in SHEET1 and SHEET2, the data is sorted by rows and it is these rows, I would like to compare.
For instace if you take Row nr 2 in Sheet1, column A=31693477
B=38140777,C=10000100,D=0000000700. If I do a search for A=31693477 in SHEET2, I will find the similar corresponding data in Row 8.
Well, the script in this case would write it out in a new file side by side and row by row so that it makes things easier to see which data is in SHEET1 and SHEET2 and which one is not. I hope I did not confuse you too much. To make things even easier, one could exclude to compare column D. For Column C in SHEET1, Excel has added two extra zeros and I hope there is a way one can remove those extra zeros.