Questions tagged [Google Sheets] (245)

0
answer

How to copy the line with the functionality to paste into another sheet in Google Spreadsheet?

Option 1 =REGEXEXTRACT( INDEX(IMPORTHTML("https://readmanga.me/vo_vseorujii__perezapusk_";"table";0);2;1); ".*?\-.*?(\d+)" ) Option 2 While improvement
darius_MacGyver16 asked April 19th 20 at 12:49
1
answer

How to make the empty cell was blank?

Using the formula in the ARRAYFORMULA a set of numbers (long code) 30091968369303 on different cell units are posted into a single cell, all the twos in another, etc. Those figures, which are not present in the long code, I would like to see a dash (-). So wizualna looks. The table on this link: https://docs.google.com/spre...
Ena.Macejkov asked April 19th 20 at 12:44
1
answer

Is it possible to make the display ARRAYFORMULA in merged cells?

Using the formula with ARRAYFORMULA I have a set of figures 30091968369303 on different cell units are posted into a single cell, all the twos in another, etc. And everything would be fine and rules, but I have in the place where are posted the numbers is to merge cells (for a better visualization of the matrix) and theref...
isaiah_Reing asked April 19th 20 at 12:44
1
answer

How to write the formula for the sample values from column 1 calculate the sum of values from columns 2 and 3?

There is a sign of a product (e.g., color), which is located in column 1, the number of items in column 2 and the value of the goods in column 3. I want some cell to output the total value of goods of certain colors (say, blue and green). In General, the sample values from the column 1 to the sum of the values in columns 2 ...
alyson_Bahringer asked April 19th 20 at 12:40
1
answer

As the set of numbers to sort in different cells?

We would like to make life easier, solving the following problem: there is a set of numbers and you need to post this whole long code in the appropriate cells as shown on the picture: all units, and four of them in one cell, two in another. If not present the numbers in the code, for example, no sixes and eights, then a da...
Clementina.Kulas66 asked April 19th 20 at 12:32
2
answers

How to import data in Google Sheets?

Not all of the data and some required data. Any URL from this domain neprimer, https://readmanga.me/hero__i_quit_a_long_time_ago By scrolling down, there is a table. And it is the very first line. The data is a number that is at the moment is 90 and release date 17.04.20 at the moment I only need these two numbers sepa...
Margret asked April 19th 20 at 12:28
1
answer

As for the Google grid to display a string from another site online?

Example: I need to be the domain of these website https://readmanga.me/rashititel_grobnic Display a row from a table (1-49) and a separate date of publication. Example table: Is it possible ?
Shanie.Eichmann63 asked April 19th 20 at 12:28
2
answers

How to calculate quersumme in the table?

The problem is that were counting quersumme like here , only in Google spreadsheets. Wrote for example in a single cell in MARY, the other shows the sum of 22.
juwan.Nol asked April 19th 20 at 12:24
1
answer

With the help of which to distinguish people's names from the flow of the text?

There is a line of text, most of which allegedly contain the names of the people. Is there a tool that can highlight a name from each row? The web terminal application or the macro for Google Sheets / Excel. Example: Anna Kalashnikova → Anna Kovalchuk Julia/Julia Kovalchuk → Julia Maria Bathan ENGLISH TEACHER → Maria SHEI...
Daphney_Carroll asked April 19th 20 at 12:05
1
answer

Pull data from one of two related IMPORTRANGE Google sheets?

There are two related function IMPORTRANGE Google table table 1 and table 2. In table 2 the calculator with data entry In table 1 performs all internal calculations, the results of which are shown in table 2. For example, table 2 I have the access editor, how to get data from all sheets from table 1 ? Which is configured t...
Verla68 asked April 19th 20 at 12:01