Đang Thực Hiện

118218 Excel Data Comparison Script

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.

Kỹ năng: Bất kì công việc gì, Nhập liệu, Javascript, Microsoft Access, MySQL, SQL

Xem thêm: sorted data set, sorted data, script sheets, make data entry easier, datas entry, data entry macro, row b, macro excel, comparison search, macro script file, write macro, excel row column, data compare, excel macro row, compare rows excel, javascript write excel, write script file, excel column row, excel compare script, excel compare row, write file excel, column row excel, job search script, write file macro excel, write script data entry

Về Bên Thuê:
( 10 nhận xét ) Stockholm, Sweden

Mã Dự Án: #1864386

Đã trao cho:

rajeshsonisl

As discussed! Thanks

$130 USD trong 2 ngày
(591 Đánh Giá)
7.4