Fastest way to find Duplicates Entries In Google Sheets

[xMelvs]

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.

[marktanlao]

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

[xMelvs]

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

You're always welcome sir

[bohboh]

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

[masterrex]

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!

[Rameshvijay45]

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

[xMelvs]

Pretty guys, thankyou for appreciate. Glad to help cheers. And goodluck

[hidrocop]

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

[mamesso]

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.

[Zadicar]

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.

[xMelvs]

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

[LUGHUL]

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.

[jemarie20]

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.

[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. 

[carlfebz2]

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.