How to Speedup Formula processing

DevopRaj
Posts
2
Registration date
Thursday September 23, 2021
Status
Member
Last seen
February 8, 2022
- Feb 8, 2022 at 06:05 PM
TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
- Feb 17, 2022 at 11:54 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)

1 reply

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
510
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