How to Speedup Formula processing

Closed

DevopRaj Posts 2 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)

How to Speedup Formula processing
Logitech formula vibration feedback wheel driver - Download - Drivers
Date formula in excel dd/mm/yyyy - Guide
Number to words in excel formula - Guide
Excel grade formula - Guide
Credit summation formula - Guide

2 responses

Answer 1 / 2

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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

Answer 2 / 2

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.

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

How to calculate position (1st,2nd,3rd) in excel....?

Calculation of positions in excel

formulas for 1st and 2nd position in class

Similar discussions

Subscribe To Our Newsletter!