Bitcoin Forum

Other => Beginners & Help => Topic started by: LiluSG on May 14, 2018, 01:53:14 PM



Title: Quick search for duplicates in Google tables (Bounty Spreadsheet)
Post by: LiluSG on May 14, 2018, 01:53:14 PM
Hello, friends :)
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 :)

https://cdn-images-1.medium.com/max/800/1*3ifsey9f6IseuWVtHTy0qQ.jpeg

2. Next, go to the toolbox for formulas. Format > Conditional formatting

https://cdn-images-1.medium.com/max/800/1*n3Jt_gq1LIyb839cOljx9A.jpeg

3. In the panel on the right, you need to choose  -  Custom Formula is

https://cdn-images-1.medium.com/max/800/1*e5J9vc9hyt6Acrw7cB9YnQ.jpeg

The formula we have of this type:
 
Quote
=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 :)