Fastest way to find Duplicates Entries In Google Sheets

carlfebz2

hero member

Activity: 2926

Merit: 722

DGbet.fun - Crypto Sportsbook

Quote from: ?? on ??

Found this quite recently. Does it really work?

Why wont you try? Instead on bumping an old thread.You can search up some tut online and i would do it for you if you are that lazy..

https://www.youtube.com/watch?v=i4giQdVDaFc
https://www.youtube.com/watch?v=sJ1pSMNM6r0
https://www.youtube.com/watch?v=ADArCWLz55Y

This is indeed helpful when you are doing community management.

chenille

full member

Activity: 428

Merit: 172

chenille!

I hope all bounty managers will do this, it's very easy to cheack and sort out the cheaters. But most managers must go further. When it comes to better cheaters like such who copy other bounty participant's articles for a content campaign most bounty managers don't check carefully because it's too much work. This needs to be improved, there are so many cheaters and it's just unfair for those who write all articles by themselves and the cheaters just copy our articles. Sad

jemarie20

member

Activity: 434

Merit: 10

This information is very useful to see many scammers now who are doing their best to earn more money even in the wrong ways, hope this situation end and scammers stop doing bad things and learn how to love others.

LUGHUL

jr. member

Activity: 387

Merit: 1

Thanks. I have an acquaintance who is a bounty manager, and I will share this article with him so he can prevent people from cheating. Once again, thank you.

xMelvs

jr. member

Activity: 266

Merit: 1

Quote from: Zadicar on November 12, 2018, 01:58:41 PM

Quote from: xMelvs on October 28, 2018, 11:39:39 PM

Hi to all

This topic is for the bounty managers. You can now easily find the duplicates and highlights it

1. Select the what you want to filter the duplicates.
2. Click Format
3.Click Conditional formatting
4. Click Add new rule
5. Set Format cells if to: Custom formula is:
6. Set value to: =countif(A:A,A1)>1
7. Set the formatting style.
8. Ensure the range applies to your column (e.g., A1:A100).
Done. Anything you write in the A1:A100 cells will be checked, and if there is a duplicate (occurs more than once) then it'll be coloured.

For multiple columns, use countifs.

Useful for those bounty mangers out there but I agree on the thing said above that managers are too lazy or yet they are just applying their alts.So, it would really be useless at all.
This settings is just a simply excel rule but most of managers I do see do failed up on this implementation.

Thanks for the feedbacks

Zadicar

legendary

Activity: 1386

Merit: 1020

DGbet.fun - Crypto Sportsbook

Quote from: xMelvs on October 28, 2018, 11:39:39 PM

Hi to all

This topic is for the bounty managers. You can now easily find the duplicates and highlights it

1. Select the what you want to filter the duplicates.
2. Click Format
3.Click Conditional formatting
4. Click Add new rule
5. Set Format cells if to: Custom formula is:
6. Set value to: =countif(A:A,A1)>1
7. Set the formatting style.
8. Ensure the range applies to your column (e.g., A1:A100).
Done. Anything you write in the A1:A100 cells will be checked, and if there is a duplicate (occurs more than once) then it'll be coloured.

For multiple columns, use countifs.

Useful for those bounty mangers out there but I agree on the thing said above that managers are too lazy or yet they are just applying their alts.So, it would really be useless at all.
This settings is just a simply excel rule but most of managers I do see do failed up on this implementation.

mamesso

hero member

Activity: 2114

Merit: 740

Leading Crypto Sports Betting & Casino Platform

I am very annoyed with them, thieves.
and managers should be wise and careful to examine this case. some managers make mistakes by giving 0 to both.
the owner of the account must prove that he is right.

hidrocop

sr. member

Activity: 630

Merit: 267

I don't understand why people are doing this, and they're still doing it. All bounty managers now control they fake accounts.

xMelvs

jr. member

Activity: 266

Merit: 1

Pretty guys, thankyou for appreciate.

Glad to help

cheers. And goodluck

Rameshvijay45

jr. member

Activity: 84

Merit: 1

Hmm very nice I think these commands is for Google sheet ok hope it will be useful to bounty managers

masterrex

full member

Activity: 1820

Merit: 107

Quote from: xMelvs on October 28, 2018, 11:39:39 PM

Hi to all

This topic is for the bounty managers. You can now easily find the duplicates and highlights it

1. Select the what you want to filter the duplicates.
2. Click Format
3.Click Conditional formatting
4. Click Add new rule
5. Set Format cells if to: Custom formula is:
6. Set value to: =countif(A:A,A1)>1
7. Set the formatting style.
8. Ensure the range applies to your column (e.g., A1:A100).
Done. Anything you write in the A1:A100 cells will be checked, and if there is a duplicate (occurs more than once) then it'll be coloured.

For multiple columns, use countifs.

Cool is it really working and whats kind of application is this? Will it is the common problem of Bounty Campaigns nowadays people are being lazy and tried to cheat at most of the campaign.I hope it will help to reduce this unnecessary cheating activities!

bohboh

jr. member

Activity: 499

Merit: 1

I hope it's works, although it's cumbersome to understand especially for those who are not familiar with spreadsheet rows and column.
Thanks mate... I'll try it out

xMelvs

jr. member

Activity: 266

Merit: 1

Quote from: marktanlao on October 29, 2018, 10:52:10 AM

thank you very much bro... its help me alot to find cheaters

You're always welcome sir

marktanlao

jr. member

Activity: 294

Merit: 1

thank you very much bro... its help me alot to find cheaters

xMelvs

jr. member

Activity: 266

Merit: 1

Hi to all

This topic is for the bounty managers. You can now easily find the duplicates and highlights it

1. Select the what you want to filter the duplicates.
2. Click Format
3.Click Conditional formatting
4. Click Add new rule
5. Set Format cells if to: Custom formula is:
6. Set value to: =countif(A:A,A1)>1
7. Set the formatting style.
8. Ensure the range applies to your column (e.g., A1:A100).
Done. Anything you write in the A1:A100 cells will be checked, and if there is a duplicate (occurs more than once) then it'll be coloured.

For multiple columns, use countifs.

Topic: Fastest way to find Duplicates Entries In Google Sheets (Read 260 times)