How to Speedup Formula processing

Closed
DevopRaj Posts 1 Registration date Thursday 23 September 2021 Status Member Last seen 8 February 2022 - 8 Feb 2022 à 18:05
Jameswalter2050 Posts 6 Registration date Saturday 27 August 2022 Status Member Last seen 20 September 2022 - 27 Aug 2022 à 03:48
I have been using this formula which macthes the List of Cells to Raw String and if match found then write same value.

This function is working fine but it stucks and sheet gets stop due to the large set of data.

I would appreciate your help if someone can share a fastest way.

Sheet is stuck from past 10 minutes.

=INDEX($K:$K,AGGREGATE(15,7,ROW($K$3:$K450000$)/(ISNUMBER(SEARCH(" "&$K$3:$K$450000&" "," "&A3&" "))),1)
Related:

2 responses

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
17 Feb 2022 à 11:54
Hi DevopRaj,

Could you show some sample data and explain what you are trying to achieve.

Best regards,
Trowa
Jameswalter2050 Posts 6 Registration date Saturday 27 August 2022 Status Member Last seen 20 September 2022
27 Aug 2022 à 03:48

Turning off Excel's automatic calculation behavior can dramatically speed up your macros. The idea is to put Excel in Manual Calculation mode, run your code, and then switch back to Automatic Calculation mode.