Bitcoin Forum
September 26, 2020, 09:20:38 PM *
News: Latest Bitcoin Core release: 0.20.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Quick search for duplicates in Google tables (Bounty Spreadsheet)  (Read 263 times)
LiluSG
Full Member
***
Offline Offline

Activity: 588
Merit: 197


View Profile
May 14, 2018, 01:53:14 PM
Last edit: June 12, 2018, 01:54:08 AM by LiluSG
Merited by RuSS512 (13), travwill (2), defyance (2), aumusxou (2), spike420211 (1), leetcoiner (1), Taya Afi (1)
 #1

Hello, friends Smiley
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



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



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



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 Smiley
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!