•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I want to create an array of references with variable dimensions
I want to use the index function to pick stuff from an array, but the location and size of that array are subject to change. I tried making an array with address functions, like =index(address(address stuff):address(address stuff)),index stuff) , but that doesnt work. Is there another way to get that array?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#financial modeling with spreadsheets
#Excel compatibility
#Excel alternatives for data analysis
#array
#index function
#array of references
#address functions
#dimension
#location
#size
#references
#variable
#pick
#stuff
#dynamic array
#change
#submit
#formulas
#error