urgent project: format multiple excel files for duplicate entries
$10-30 USD
Betalt ved levering
we have 20 excel files, each with about 500 rows of data and 10 columns in each row. Each file has unique and duplicate row of data. we need to format data to highlight duplicate data in each file. However note that data could be duplicated across any file. for example file 1 row 20 data might be in file 5, row 10. then this data in file 5 row 10 should be highlighted.
the unique identifier for each data is "product url" column (column E in the file). if the product url is same in other row entries, then it is a duplicate data.
we want to find duplicate entries in each file which should be highlighted as follows:-
1)
files are numbered from 1 to 16. you would start with file 1 and search all other 15 files for duplicate entries of record from file 1. if any entry is duplicate, then that row will be highlighted in "orange color" in those files where this data is found
2) before you move to file 2, if any data in file 2 is already highlighted in orange color, then you would skip this row. otherwise the original file data would be highlighted in your next search that you do in step 3
3)
then you would search file 2, and search all files including file 1. if any data is duplicated, you would follow the same step above. it is important that you skip those data that is already highlighted
4) Repeat this step until the last file. this way all the 20 files would show any duplicate data content that is highlighted.
this is very simple and easy task and it is very urgent, we need this done in one day, without any errors. you would send us back the formatted 20 files that we have sent you.
i have attached a small portion of data from a file for your reference.
Projekt ID: #11068941
Om projektet
20 freelancere byder i gennemsnit $33 timen for dette job
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Hi, Could you please send me over all the 20 files, so that I shall send you a sample ? Interested to work on this. Kindly discuss further so that let's get started. Ready to start right away. Thanks BP Web Anal Flere
I am interested to do this project............... Can start now.............................................Lets start
Hello I am highly interested to do your project. I beleive that, I can do this work properly and in timely by your instruction. Always determined to give you a best work. Moreover, I have a efficient group whic Flere
Hi, I am a software developer and I can help you by making and standalone application using VB to read all Excel files. They could be in the same folder, and the application I'd build will be there too, so, it will rea Flere
I am an excel expert, it will be very easy for me to do this task, will provide you the updated file within 3 day. I will prove to be best option of resource you opt for. Looking forward for your revert, so that i can Flere
Hello, I understand clearly everything what you said in your job post and I'm ready to work with you immediately if given a chance.
im good in excel and im confident i can meet the target to do the job, im available for discussion of client's requirements
