Suoritettu

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

Taidot: Excel, Tietojenkäsittely, Google Sheets

Näytä lisää: 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

Tietoa työnantajasta:
( 9 arvostelua ) Jakarta, Indonesia

Projektin tunnus: #31609331

Myönnetty käyttäjälle:

(310 Arvostelua)
7.1

12 freelanceria on tarjonnut keskimäärin $21 tähän työhön

(133 arvostelua)
6.1
(94 arvostelua)
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 1 päivässä
(10 arvostelua)
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 1 päivässä
(1 arvostelu)
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 Lisää

$20 USD 7 päivässä
(0 arvostelua)
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 1 päivässä
(0 arvostelua)
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 7 päivässä
(0 arvostelua)
0.0
websiteappdev

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

$20 USD 1 päivässä
(0 arvostelua)
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 Lisää

$10 USD 7 päivässä
(0 arvostelua)
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 7 päivässä
(0 arvostelua)
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 7 päivässä
(0 arvostelua)
0.0