Færdiggjort

Google Sheet - Script to Remove Duplicate Based on 2 Column Criteria

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

Evner: Excel, Databehandling, Google Sheets

Se mere: script remove duplicate email, google sheet script print, Google Sheet Script, https://www.freelancer.com/?t=d&utm_expid=294858-461.bpfvrHBWScioB-xelFmk_g.2&gclid=Cj0KEQjw9vi-BRCx1_GZgN7N4voBEiQAaACKVoYRsKOX, https://docs.google.com/spreadsheets/d/1BoluYWe-QeEmRDwp1nHYwzJw5AZwmHxdjsMlLuv8Lns/edit?usp=sharing, https://docs.google.com/document/d/1P91pjDiYz7TYLyZkYvKG2BLrKux4-BY8uJ8DA6MpOQI/mobilebasic, https://docs.google.com/, https://docs.google.com/drawings/, https://docs.google.com/drawings/d, https://docs.google.com/drawings, split excel sheet into multiple files based on column, https docs google com spreadsheets u 0 /\, split excel sheet into multiple sheets based on column value, split excel sheet into multiple workbooks based on column, google sheet script editor, google sheet script api, google sheet script email reminder, split excel sheet into multiple files based on column vba, google sheet script tutorial, macro to split excel sheet into multiple tabs based on column value

Om arbejdsgiveren:
( 9 bedømmelser ) Jakarta, Indonesia

Projekt ID: #31609331

Tildelt til:

(310 bedømmelser)
7.1

12 freelancere byder i gennemsnit $21 timen for dette job

(133 bedømmelser)
6.1
(94 bedømmelser)
6.3
hritikdanng

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.

$30 USD på 1 dag
(10 bedømmelser)
3.7
sinawab

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

$20 USD på 1 dag
(1 bedømmelse)
1.0
Aamiraliwarer

Hello sir, I understand you are looking for an excel and google spreadsheet. I am expert and can do this work excel and google sheet. I can do this work within a given time. so you expect top quality of work. I own a Flere

$20 USD in 7 dage
(0 bedømmelser)
0.0
Gayansandun95

Hi there. I'm interested in this project. I can handle this project efficiently. If you like to work please contact me and send you work. Thank you

$15 USD på 1 dag
(0 bedømmelser)
0.0
yhimabindu1607

I use my forefingers a lot, but other fingers too. I type at about 40 words per minute. I’m very very fast on the number keypad for number data entry.

$20 USD in 7 dage
(0 bedømmelser)
0.0
websiteappdev

✅ Hello, I will remove the DUPLICATES right away. Looking forward to hearing from you. Warm Regards, Mukesh

$20 USD på 1 dag
(0 bedømmelser)
0.0
Rekhankanle62

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 Flere

$10 USD in 7 dage
(0 bedømmelser)
0.0
abhishekkagday

data entry expert my hobe is to take my custmar happy in to take money give in the my account my full experince is data entery

$20 USD in 7 dage
(0 bedømmelser)
0.0
surajkumar4444d3

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

$20 USD in 7 dage
(0 bedømmelser)
0.0