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

Quote from: xMelvs on October 29, 2018, 04:39:39 AM

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