Hi
I am trying to input a match formula into my sheet but it has over 200,000 rows and is very slow to calculate:
Does anyone know if this can be achieved another way that is faster?Please Login or Register to view this content.
Hi
I am trying to input a match formula into my sheet but it has over 200,000 rows and is very slow to calculate:
Does anyone know if this can be achieved another way that is faster?Please Login or Register to view this content.
Isn't this essentially the same as what you've asked here??
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Well, as that particular code takes about 4 mins to run, I was trying to use a helper column hence entering the formula.
I wanted to use this to identify and delete the rows.
I will close this one and continue on the other thread.
Duplicate closed. Please continue here: https://www.excelforum.com/excel-pro...o-execute.html
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks