SOLVED

Excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-3277702%22%20slang%3D%22en-US%22%3EExcel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3277702%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20to%20get%20excel%20to%20create%20a%20series%20of%20numbers%20based%20on%202%20given%20numbers%2C%20for%20example%20if%20you%20enter%205%20in%20one%20cell%20and%2010%20in%20another%20cell%20so%20that%20it%20can%20create%20numbers%20from%205%20to%2010%2C%20or%20for%20example%20100%20in%20one%20cell%20and%20500%20in%20another%20cell%20so%20that%20it%20create%20numbers%20from%20100%20to%20500%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3277702%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3278572%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3278572%22%20slang%3D%22en-US%22%3EGlad%20I%20could%20help.%20Nice%20day...%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3278568%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3278568%22%20slang%3D%22en-US%22%3EHi%3CBR%20%2F%3E1000%20thanks%2C%20now%20it%20works.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3278552%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3278552%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1355163%22%20target%3D%22_blank%22%3E%40Monika_Betina%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20suspect%20your%20formula%20separator%20(based%20on%20your%20Regional%20settings)%20is%20not%20the%20comma%20but%20something%20else%2C%20i.e.%26nbsp%3B%3CSTRONG%3E%3B%20%3C%2FSTRONG%3Ein%20which%20case%20the%20formula%20would%20be%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DSEQUENCE(B1-A1%2B1%3B%3BA1)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOpen%20the%20attached%20file%2C%20Excel%20will%20figure%20it%20out...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3278536%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3278536%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20it%20is%20365%3C%2FP%3E%3CP%3EIt%20says%20that%20there%20are%20an%20issues%20hvid%20this%20formula....%3C%2FP%3E%3CP%3E%22Are%20you%20trying%20to%20write%20a%20formula%3F%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20the%20first%20sign%20in%20a%20equal%20sign%20(%3D)%20or%20a%20(-)%2C%20the%20excel%20think%20it%20is%20a%20formula%3A%26nbsp%3B%3C%2FP%3E%3CP%3E*%20If%20you%20write%20%3D1%2B1%2C%20it%20shows%202%20in%20the%20celle%3C%2FP%3E%3CP%3EYou%20can%20solve%20it%20by%20writting%20a%20(%22)%20as%20a%20first%20sign%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3277812%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3277812%22%20slang%3D%22en-US%22%3EWhat%20version%20(2013%2C%202016...365)%20of%20Excel%20do%20you%20run%3F%20If%202021%20or%20365%20what%20is%20the%20exact%20error%20message%20you%20get%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3277754%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3277754%22%20slang%3D%22en-US%22%3EThanks%20for%20the%20quick%20answer%20but%20it%20didn't%20work%2C%20it%20says%20that%20there%20are%20a%20formula%20issues%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3277720%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3277720%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1355163%22%20target%3D%22_blank%22%3E%40Monika_Betina%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%20with%2010%20and%2050%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot.png%22%20style%3D%22width%3A%20170px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F361783i02942DE6F55255EB%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screenshot.png%22%20alt%3D%22Screenshot.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFormula%20in%26nbsp%3B%3CSTRONG%3EA2%3C%2FSTRONG%3E%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DSEQUENCE(B1-A1%2B1%2C%2CA1)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New Contributor

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?

7 Replies

Hi @Monika_Betina 

 

Example with 10 and 50

Screenshot.png

 

Formula in A2:

=SEQUENCE(B1-A1+1,,A1)
Thanks for the quick answer but it didn't work, it says that there are a formula issues
What version (2013, 2016...365) of Excel do you run? If 2021 or 365 what is the exact error message you get?

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"

best response confirmed by Sergei Baklan (MVP)
Solution

Hi @Monika_Betina 

 

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...

Hi
1000 thanks, now it works.
Glad I could help. Nice day...