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!