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 &...
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 ...
You can copy paste the data in a tab free of data in column A.
Then in column B1 you can use this :
Copy the cell for every data you have in column A
Copy Column B then paste with the option values only
FORMULATEXT() is self-explanatory : it returns a formula based on a cell I.E. the string =+/- x here....
Yes you can do it. There are a lot of approaches for this problem.
=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 ...
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:
In cell A3, paste ...