Apr 06 2022 06:13 AM
How to get excel to create a series of numbers based on 2 given numbers, for example if you enter 5 in one cell and 10 in another cell so that it can create numbers from 5 to 10, or for example 100 in one cell and 500 in another cell so that it create numbers from 100 to 500?
Apr 06 2022 06:21 AM
Apr 06 2022 06:49 AM
Apr 06 2022 07:37 AM
Apr 07 2022 12:57 AM
Hi, it is 365
It says that there are an issues hvid this formula....
"Are you trying to write a formula?
When the first sign in a equal sign (=) or a (-), the excel think it is a formula:
* If you write =1+1, it shows 2 in the celle
You can solve it by writting a (") as a first sign"
Apr 07 2022 01:12 AM
Solution
I suspect your formula separator (based on your Regional settings) is not the comma but something else, i.e. ; in which case the formula would be:
=SEQUENCE(B1-A1+1;;A1)
Open the attached file, Excel will figure it out...
Apr 07 2022 01:12 AM
Solution
I suspect your formula separator (based on your Regional settings) is not the comma but something else, i.e. ; in which case the formula would be:
=SEQUENCE(B1-A1+1;;A1)
Open the attached file, Excel will figure it out...