Hello, friends
![Smiley](https://bitcointalk.org/Smileys/default/smiley.gif)
First of all, this topic refers to bounty tables.
If managers do not know about this method, they can take it into service. Also, any member of the bounty, can now openly look for duplicates
In my case I copy or parsing Google spreadsheet to himself. In manager case, you have direct access to the page
1. Select the column in which to search for duplicates.
The formula works on the whole table, but it’s difficult for me to explain in another language. Therefore, the fastest way
![Smiley](https://bitcointalk.org/Smileys/default/smiley.gif)
![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fcdn-images-1.medium.com%2Fmax%2F800%2F1%2A3ifsey9f6IseuWVtHTy0qQ.jpeg&t=665&c=Xs7HQW8ES0426w)
2. Next, go to the toolbox for formulas.
Format > Conditional formatting![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fcdn-images-1.medium.com%2Fmax%2F800%2F1%2An3Jt_gq1LIyb839cOljx9A.jpeg&t=665&c=VGbu3yHktupQKA)
3. In the panel on the right, you need to choose -
Custom Formula is![](https://ip.bitcointalk.org/?u=https%3A%2F%2Fcdn-images-1.medium.com%2Fmax%2F800%2F1%2Ae5J9vc9hyt6Acrw7cB9YnQ.jpeg&t=665&c=aDwq7JUXMRMGHg)
The formula we have of this type:
=AND(NOT(ISBLANK(C1)); COUNTIF($A$1:$F; "=" & C1) > 1)
Where the first and second
C is the number of our pillar
And as a result, duplicates will be painted. The formula can be applied to each pillar. Good luck
![Smiley](https://bitcointalk.org/Smileys/default/smiley.gif)