It’s fine, but the worst part is how long it takes to sort by the column that is all calculations.
The calculation I’m using is this: =VLOOKUP(H10,U:V,1,0). On the sheet I’m currently using, the calculation returns a value on 8 lines, returns “#N/A” on 828 lines. So far, so good. To sort by that column and bring all the lines that returned a value to the top, however, takes greater than 60 seconds and lots and lots of CPU churn. If I sort by a column of normal numbers, the sort is instantaneous.
While testing various things to write this question, I found the really long lag only occurs sporadically. Just now I put in a longer list than the 8, and even with a longer list of matches/returned values, the sort was basically instantaneous. But the really long lag is frequent, and occurred more than half the times in my tests.
I’m going to repeat this method about a million times in a million documents almost every work day (unless I relent and purchase good ole’ Excel out of my own pocket), and would love to know what is causing the lag, and a surefire way to avoid it (and safe way to kill the process if I screw up and accidentally initiate this mess?).
Any idea what’s causing it and how I can stop it?
edit: and most times the progress bar shows slow, steady progress and when it’s done, it has done the job correctly–at least. But just now the progress bar finished, and now it’s locked up.