I think it was a similar reply the last time I asked :-) Bob
R Roni Apr 26, 2005 #22 Aladin, That's true, the array formula takes a lot of time to process big excel file. Are there any ways to fasten the processing time for array formula? Thanks, Roni
Aladin, That's true, the array formula takes a lot of time to process big excel file. Are there any ways to fasten the processing time for array formula? Thanks, Roni
A Aladin Akyurek Apr 26, 2005 #23 Roni said: Aladin, That's true, the array formula takes a lot of time to process big excel file. Are there any ways to fasten the processing time for array formula? Thanks, Roni Click to expand... Yes, if you can sort the data, calculate the subranges (in additional columns, and apply the array formula to calculated subranges. Why not try the proposal for concatenating, sorting, and invoking a LOOKUP formula for it will certainly beat the foregoing in performance?
Roni said: Aladin, That's true, the array formula takes a lot of time to process big excel file. Are there any ways to fasten the processing time for array formula? Thanks, Roni Click to expand... Yes, if you can sort the data, calculate the subranges (in additional columns, and apply the array formula to calculated subranges. Why not try the proposal for concatenating, sorting, and invoking a LOOKUP formula for it will certainly beat the foregoing in performance?
