New answers tagged

0

I've found the answer to my own question, through another post https://stackoverflow.com/a/54608779 It seems query only allow one of two things in a single query, so I cannot do both divide by & sum in one go. Alternatively I used another method from the other post to reach the solution. Arrayformula(Query(Query({data range},"Select etc."), &...


0

This is perhaps easier to do without query(), like this: =arrayformula(L42:L63 * N42:N63 / sum(L42:L63))


0

This answer is an adaptation of an answer by @Calculuswhiz to Shuffle comma-separated list of values in one cell (Google Sheets) on StackOverflow. There is one key difference between the scenario of this question and the StackOverflow question. In StackOverflow, the values were already in a comma separated list. In this question, the values are in a list ...


1

With the dates in A2:A9, use ifs() in an array formula like this: =arrayformula( regexreplace( textjoin( "", true, ifs( (A2:A9 <> A1:A8 + 1) * (A2:A9 <> A3:A10 - 1), trim(A2:A9) & ", ", (A2:A9 = A1:A8 + 1) * (A2:A9 = A3:A10 - 1), "", (A2:A9 = A1:A8 + 1), trim(A2:A9)...


1

AND does not work with array formulas; you have to use * instead. (Likewise, OR does not work with array formulas, and you must use + instead.) You also have redundancies in the formula. It is always difficult to try to write a formula without access to the spreadsheet, layout, data types, etc. And, of course, there's no way to test a formula in the dark ...


0

I can't see anything wrong with your formula except that you have far too many closing brackets at the end. This should work: =arrayformula(IF(H2:H="",,IF(AND(ISNUMBER(SEARCH("Maestría en Finanzas",H2:H)), ISNUMBER(SEARCH("EGADE en Línea",J2:J))),"MAFO",IF(AND(ISNUMBER(SEARCH("Maestría en Finanzas",H2:H)), ...


Top 50 recent answers are included