1

First thing to have in mind is that Google Sheets (as well as other spreadsheet apps) use serial numbers to handle dates, so when a value looks like 8/15/2019 (if it's handled as date and not as text) Google Sheets internally handle this value as 43692. Recarding COUNTIF, this function requires two arguments and if you will use a comparison operator like &...


1

There's a way without dragging a cell with Arrayformula : =ArrayFormula(ROW(INDIRECT("A1:A"&A2))) Where A2 is the n value There's no incrementation in Google spreadsheet so the only way is to find a build-in counter : the rows/columns. ROW() and COLUMN() return the adress of a cell or an array with Arrayformula. Now your case is using a dynamic ...


1

You can copy paste the data in a tab free of data in column A. Then in column B1 you can use this : =REGEXREPLACE(formulatext(A1),"=",) Copy the cell for every data you have in column A Copy Column B then paste with the option values only Explanation : FORMULATEXT() is self-explanatory : it returns a formula based on a cell I.E. the string =+/- x here....


1

Yes you can do it. There are a lot of approaches for this problem. Example : =QUERY(A:B,"SELECT * WHERE "&C1&C2") Cell C1, C2 contains the rest of the query like C1 B = 'Apples' C2 OR B = 'Peaches' You can build C1 and C2 with conditions such as C1 =IF(D1<>"","B = '"&D1&"'","") Where D1 is your fruit's name Then build ...


1

In cell A2, put your integer seed value - this can be anything, but a small number is fine (something like "34"). In cell A1, paste the following formula which auto-seeds the first cell of the pseudorandom sequence: =MOD(ROUND(2147483647*16807*MOD(ROUND(MOD(A2*EXP(1),1)*2147483647*16807,0),2147483647)/2147483647,0),2147483647)/2147483647 In cell A3, paste ...


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