How to Speedup Formula processing

Closed
DevopRaj Posts 1 Registration date Thursday September 23, 2021 Status Member Last seen February 8, 2022 - Feb 8, 2022 at 06:05 PM
Jameswalter2050 Posts 6 Registration date Saturday August 27, 2022 Status Member Last seen September 20, 2022 - Aug 27, 2022 at 03:48 AM
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)

2 responses

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

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

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

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.

0