Create a macro.
sheet A: here u will copy and past manually the data u want processed. sheet B/c - will do some calculations and a macro to run., sheet d - end result - unique recoreds as per your request
27 freelancers are bidding on average $27 for this job
It shouldn't be a problem to write this macro Relevant Skills and Experience I have created macros in my current job for such things Proposed Milestones $20 USD - Creating the macro
Many are just placing bids in 2 days but a good design and code needs some time and i will deliver this in that way. Let's discuss the requirement in details please.