Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
3

Simplifying fractions can easily be done with the GCD-function (Greatest Common Divisor). Using this function =A1/GCD(A1;B1) & ":" & B1/GCD(A1;B1) will give you this result: A B C 1 2 5 2:5 2 5 15 1:3 3 8 18 4:9 If you really want half points, just multiply all values with two and at the end divide them by two again: =(2*A1/...


1

On Firefox used Alt + Up and Alt + Down to move the worksheet and avoid conflicts with moving the browser tab.


1

=IFERROR($C5*GOOGLEFINANCE("currency:"&$C4&D6), $C5)


1

=QUERY(C4:D, "select C,sum(D) where C <>'' group by C label sum(D)''") =SUMIF(C$4:C, F4, D$4:D)


1

=ARRAYFORMULA(TEXT(SUBSTITUTE(SUBSTITUTE(A2:A, " h ", ":"), " m", ":00"), "[h]:mm"))


1

There are no such tools. The culprit is either extensive usage of QUERY formulas, IMPORT formulas, complex ARRAYFORMULA formulas with multiple virtual sub-calculations/sub-references and most likely it's done on a large unnecessary range eg a portion of blank cells is included in calculation which may have a negative impact on overall performance. It all ...


1

As it was mentioned on the other answer Google doesn't offer a place that include a list of the connected spreadsheets but you could create automatically that list by using Google Apps Script. The access rights that the connection implies is read only and it's granted to the account that authorized the access. This connection will work while the authorizer ...


1

You are not able to check for "connection" anywhere in Google Sheets. Such a feature does not exist at the moment. As for the "what access rights" part: a spreadsheet that is connected can be read (scrapped) with IMPORTRANGE function and this can also be exploited to gain direct access (not ownership) to the whole spreadsheet.


1

I used the script below, located in https://stackoverflow.com/q/56215898/7108653, like suggested for @Tanaike, and adjusted with just a few things (lines 3, 4 and 5). function downloadSheetAsPDF2() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheetId = ss.getSheetByName("RECEITA PARA IMPRESSÃO").getSheetId(); var valor = SpreadsheetApp....


1

=ARRAYFORMULA(IF(LEN(A1:A&B1:B&C1:C&D1:D&E1:E), MMULT(IFERROR(LEN(IFERROR(REGEXEXTRACT(A1:E, "[A-Z]+")))/ LEN(IFERROR(REGEXEXTRACT(A1:E, "[A-Z]+"))), 0), TRANSPOSE(COLUMN(A1:E1)^0)), ))


1

first you will need to pivot out series with QUERY formula and then plot the chart =QUERY(A1:C11, "select A,C,sum(C) where A is not null group by A,C pivot B", 1)


1

={A1:E1; QUERY(SORT(VLOOKUP(QUERY({ROW(D:D), SORT(A:E)}, K1, 0), {ROW(D:D), SORT(A:E)}, {2, 3, 4, 5, 6}, 0), 4, 0), "where Col4 <="&INDEX(QUERY(SORT(VLOOKUP(QUERY({ROW(D:D), SORT(A:E)}, K1, 0), {ROW(D:D), SORT(A:E)}, {2, 3, 4, 5, 6}, 0), 4, 0), "select Col4 order by Col4 desc"), 2, 1)&" and Col4 >="&INDEX(UNIQUE(QUERY(SORT(...


1

Google Sheets do NOT highlight specific words in text. Google sheets ONLY show the cells where your search terms are included After finding the right sheet, use your browser's search feature. Please pay attention on the counted results. Google Sheets function ONLY shows found cells (including the search terms) This is what you see in Google Chrome: ....


1

I found some different partially workaround, it's not perfect but I think I could be helpful: instead of sending as a parameter I sent it as a string, for example, when choosing the range it will be =example(a1:a3) I used: example("a1:a3") when I first selected the range and then changed it manually.


1

Set A1 to be the first day of the month in question. Then: =CEILING((DAY(EOMONTH(A1, 0)) - MOD(6 - WEEKDAY(A1), 7)) / 7) This works for any day of the week, just change the 6 after MOD( to the corresponding day of the week. How it works: 6 - WEEKDAY(A1) This counts the days between the first day of the month and the nearest Friday. However, we want to ...


Only top voted, non community-wiki answers of a minimum length are eligible