Volotile Array Formula Quicker alternative ?

[Destruxon]

hi all,

with the help of this forum, i have pieced a formula together which does exactly what i need, but as its being placed in around 10,000 rows and appears 10 times in each row, the volatile formula as you can imagine is taking its toll on my mediocre pc lol, can anyone recommend an alternative formula which could speed up the calculation on my sheets? any help appreciated as im very new to this excel, but im learning it quite quickly thanks to you all

the formula is:

=IFERROR(INDEX(INDIRECT("'["&Variables!$A$2&"]"&Variables!$B$2&"'!"&Variables!$C$2), SMALL(IF($A9959=INDIRECT("'["&Variables!$A$2&"]"&Variables!$B$2&"'!"&Variables!$D$2), ROW(INDIRECT("'["&Variables!$A$2&"]"&Variables!$B$2&"'!"&Variables!$C$2))-1,""), COLUMN()-7)),"")

this is finished in an array, it basically looks at another sheet and splits the data from X amount of rows into one row accross 10 cells.

thankss all

[dosydos]

without seeing your worksheet i can only guess. The reason for slowness is probably because of the Array formula {}, as these formulas take a lot of resources to run. juding by your descriptions of .....

this is finished in an array, it basically looks at another sheet and splits the data from X amount of rows into one row accross 10 cells.

This to me sounds almost like you could use a TRANSPOSE() formula perhaps?

[AliGW]

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[Destruxon]

hi AliGW , sorry about the title, i have edited it , hopefully this is now ok

[AliGW]

Yes - thanks.