SOLVED

Sequence numbers

%3CLINGO-SUB%20id%3D%22lingo-sub-2930455%22%20slang%3D%22en-US%22%3ESequence%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2930455%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20guys%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%202019%20Excel%20and%20it%20is%20not%20picking%20the%20sequence%20command%20in%20the%20formula%3F%20What%20could%20be%20wrong%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2930455%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2930625%22%20slang%3D%22en-US%22%3ERe%3A%20Sequence%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2930625%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1208115%22%20target%3D%22_blank%22%3E%40leo_mpofu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20post%20some%20image%20of%20what%20is%20happening%3F%3C%2FP%3E%3CP%3EBelow%20an%20example%20of%20the%20SEQUENCE()%20formula%20applied.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JulianoPetrukio_0-1636107517350.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F324496iBF679C649423D74D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JulianoPetrukio_0-1636107517350.png%22%20alt%3D%22JulianoPetrukio_0-1636107517350.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2930712%22%20slang%3D%22en-US%22%3ERe%3A%20Sequence%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2930712%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1208115%22%20target%3D%22_blank%22%3E%40leo_mpofu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20mean%20SEQUENCE()%20as%20in%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767933%22%20target%3D%22_blank%22%3E%40Juliano-Petrukio%3C%2FA%3E%26nbsp%3B%20example%2C%20it's%20not%20available%20for%202019.%20Update%20on%202021%20or%20better%20on%20365.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi guys 

I am using 2019 Excel and it is not picking the sequence command in the formula? What could be wrong?

3 Replies

@leo_mpofu 

Can you post some image of what is happening?

Below an example of the SEQUENCE() formula applied.

 

JulianoPetrukio_0-1636107517350.png

 

best response confirmed by allyreckerman (Microsoft)
Solution

@leo_mpofu 

If you mean SEQUENCE() as in @Juliano-Petrukio  example, it's not available for 2019. Update on 2021 or better on 365.

Thanks