Hi All,
I have a spreadsheet with a set of arrays that lookup two sets of information to find the matching data, but it is very laggy is there anything I can do to speed it up??
I have attached the sheet and highlighted in Yellow the relevant fields
Please Login or Register to view this content.
Many thanks for any input
Danny
Slow? Of course!. Do not use open ranges. Use something like B2:B100 or whatever your range is.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
I feel like a lemon, I did not notice that and Ive been raking my brains for ages.
Cheers
Indeed! It's a shame that the idea that you shouldn't reference entire columns in array formulas is not more widely known. It's amazing how many people, even some quite proficient users, are unaware of this.
Perhaps the confusion arises from the apparently inconsistent view that Microsoft have adopted here: it's well known that functions such as COUNTIF(S)/SUMIF(S) suffer no loss in performance using entire column references, so the assumption that it's also ok in other, array constructions is quite a natural one.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks