In each tab in the associated excel workbook, there are 3 tabs.
In each tab there is a source1 data and source2 data columns.
Need to match the dealer_names in source1 and source2 by examining each of thecolumns in the sources and mark the the last "correct" column as 1 for match, 0 for different, and 2 if not sure.
Needs fuzzy matching on dealer_name, address, zipcode between the two sources. Sometimes the streetnumber in addresses may not match but that can be taken as matching if it is close enough...
Add a last column to describe your criteria if not sure.
20 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Hello, I’m an Excel expert and I would like to help you with your project. I'm fully available and I can start right away. Please check my profile and contact me to discuss. Regards.
Hi Client, I can do this task of data cleanup across 2 different sources and matching them between source1 and source2 as you instructed in project description
Pleasure to help you. I can do your project. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan
HI - 59 days error free service - Continued support after the delivery of final product - Clear communication throughout the project - 100 % satisfaction guaranteed [login to view URL] `