Google Sheet - Script to Remove Duplicate Based on 2 Column Criteria
$10-30 USD
Completed
Posted over 2 years ago
$10-30 USD
Paid on delivery
Hello, this is a short quick project, probably can be solve by Google Sheet Expert under an hour.
=====================
UPDATE:
in my example, row 2,4,23,24,25,26 will be remove because, row 27 is the latest using same article and UID
==============
So here's the case
I have a spreadsheet as shown here: https://docs.google.com/spreadsheets/d/1HujF7swGmzF0WO3_EU5fyg4iQleuRbrmtIPLlEUO-Wk/edit#gid=0
Here's my objective
Duplicate Data from "RAW WEBSITE" Tab to "Final" Tab, with Data Cleaning (remove criteria) for Unique Article and UID (i want using the latest row, remove the the previous row). No Need to do cleaning if UID is not set.
For A Simple Simulation Example
Article=A, UID=8, Rating=Tidak
Article=B, UID=8, Rating=Tidak
Article=A, UID=8, Rating=Ya
Expected Output:
Article=B, UID=8, Rating=Tidak
Article=A, UID=8, Rating=Ya
First deleted because the Same Article A and UID 8 also appear in later.
Please Q&A in chat, and since this is not a complicated project, please show me the output with the sample url as source.
Thanks
Hello,
I'm expert in Excel, the task is freaking easy and I can start straight away.
Short and simplw proposal just like your task.
To discuss more message me,
Thank You.
Hello,
I have read the project descritpion and understood your requirement.
I can work for you.
We can connect for detailed understanding of project
Regards,
Sakil Nawab
I look forward to contributing my skills and experiences to your organization if given the opportunity. Sample answer 2: I'm confident that I will thrive in this position, seeing that I have all the skills that you are looking for. Having worked as a sales and marketing agent, I'm well versed with the job requirements.
I will make you satisfied with my work and make you believes on me because I understood my responsibilities very well. I will finish your work one day before the dateline this shows my talent