Roni wrote:
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


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?