google sheetsgoogle-sheets-arrayformulagoogle-sheets-dates
Cell A1 holds a numerical value (e.g. 10), and I'd like to output the list of numbers from 1 to that number in B1:
What's the formula I need for B1? It seems trivial, and I know it probably requires ARRAYFORMULA but I just don't know where to go from there.
The solution is quite simple. Press this button to increase the number of decimals:
Now it will show the correct amount of decimals:
Please be aware that this works only up to 15 digits. Beyond that, Google Spreadsheets will ignore the rest.
Right after posting the question I had a flash of inspiration…
It occurred to me that maybe I could construct the comparison string if there was a function that would concatenate strings together. Sure enough, there is a function called CONCAT that will do the trick.
So, I can do what I want with:
COUNTIF(Sheet1!$A$2:$B$130, CONCAT("=", A1))
Best Answer
It is as simple as using the following sequence formula
Or you even could have something like this:
You could even use the
SEQUENCEfunction for dates