Bitcoin Forum

I apologize for my English, I teach it less than 6 months.


Register in Google, if there is no account. And create a new table. https://www.google.ru/intl/eng/sheets/about/


https://a.radikal.ru/a08/1804/be/73ec3432522a.jpg (https://radikal.ru)

https://b.radikal.ru/b35/1804/b7/166ba4c5368f.jpg (https://radikal.ru)



Here is a table where the Manager puts stakes


https://c.radikal.ru/c03/1804/e4/a83b5459faee.jpg (https://radikal.ru)


We are interested in the code of table 1h-8ps9VQNQK033gyc09-rBOSvPVbSoZpcuwy-fz0jms, also the name of the sheet (in this case Twitter) and our line number(for example, take №6)


https://c.radikal.ru/c06/1804/bf/fb93ddd61e5c.jpg (https://radikal.ru)


In the table we created, we fill in: 1 line - the name of the bounty, 2-in which company we participate (in this case, Twitter) and in the third line we copy the function, which will import data:

=IMPORTRANGE("1h-8ps9VQNQK033gyc09-rBOSvPVbSoZpcuwy-fz0jms"; "Twitter!A6:O6")

where:
1h-8ps9VQNQK033gyc09-rBOSvPVbSoZpcuwy-fz0jms table code where Manager puts points
Twitter sheet name from the same table
A6 and O6 start column and end column of the table and our row number

A very convenient feature (binding to the name) is when the Manager constantly edits the table (removes rows) and this changes the binding of the row number.
To do this, I advise you to have a separate table, because it will constantly import data from many cells of other tables and with a large number of bounties it will be possible to add. But the convenience of it is still overlaps.

In the first line, I bring the company name and a link to the Manager table for a quick transition to it.

https://d.radikal.ru/d14/1805/20/bbd696a33cb2.jpg (https://radikal.ru)

From the Manager table we need the following data:

https://c.radikal.ru/c01/1805/14/33b39063cb18.jpg (https://radikal.ru)

In the second line we write the function =VLOOKUP this type:
On my screenshots there is a function =BПP, but in the English tables you need to use =VLOOKUP. Google sheets won't let me use it.

=VLOOKUP("AAA";IMPORTRANGE("BBB"; "CCC!B1:V5800");1;0)

Where AAA - string name to bind (Bitcointalk username) it will be the beginning of our range for importing data
              BBB - the reference to the table Manager (https://docs.google.com/spreadsheets/d/160LpOlxJmkWwwE_2BPzIwbDsVMJWyyAq6iLIxUvqCqI/edit#gid=1086350140)
              CCC - the name of the sheet from where the data will be imported
      B1:V5800 - range for importing data
                  1 - column number from our range for importing data
                  0 - leave as is
As a result, we get this function:
=VLOOKUP("Bitcointalk username";IMPORTRANGE("https://docs.google.com/spreadsheets/d/160LpOlxJmkWwwE_2BPzIwbDsVMJWyyAq6iLIxUvqCqI/edit#gid=1086350140"; "Twitter!B1:V5800");1;0)

https://c.radikal.ru/c05/1805/9b/8b0953cd787b.jpg (https://radikal.ru)

The third hundred-fate prescribed the same exact function only change in it the name of the row for the binding (our nick)

=VLOOKUP("madnessteat";IMPORTRANGE("https://docs.google.com/spreadsheets/d/160LpOlxJmkWwwE_2BPzIwbDsVMJWyyAq6iLIxUvqCqI/edit#gid=1086350140"; "Twitter!B1:V5800");1;0)

If all have made correctly get.

https://c.radikal.ru/c19/1805/b2/3dde790e147f.jpg (https://radikal.ru)

Next, copy both rows as many times as many columns we need to import from the Manager table.

https://c.radikal.ru/c21/1805/e7/12505b6f7ec5.jpg (https://radikal.ru)

Change 1 at the end of the function to as much as the desired column is moved relative to the beginning of our range.

https://a.radikal.ru/a43/1805/c7/a856374a2998.jpg (https://radikal.ru)

In the next two columns, too, change 1 to the desired column from the Manager table

https://d.radikal.ru/d39/1805/bb/d02e179c038e.jpg (https://radikal.ru)

Here such it turns out our table.

https://d.radikal.ru/d34/1805/80/03aa1112e37a.jpg (https://radikal.ru)

At first it seems that it takes too much time for this, but a little understanding you understand that such tables are made with ease. It is very convenient if you make such a table from the beginning of bounty and then do not have to edit anything.