Forum Discussion
SEQUENCE formula with curly brackets
I have this simple formula, it works as expected up until the SEQUENCE part : In short rws would equal to 32, and srt to 1 I expected this to output the same as SEQUENCE(32,1,1,1), but it outputs j...
Because your rws always retun 1. This expression INDEX(z,G1+1)-str will always return 1 and you will get final out only one cell from SEQUENCE() function. Would you explain what you want to achieve? Can you put few sample data and show your desired output? Attach a sample file or share via OneDrive or GoolgeDrive or DropBox or similar service.