Hi again about this post #1 you really should provide a sample workbook. Thats why this isnt solved yet. Some of the really brilliant ppl on the forum dont even waist there time unless you follow the rules, & that is kinda a rule here. I think, I havent read them in a while. Either way I do know, that if I am serious about getting my solution I better create one.
jindon & Vikas_Gautam have given some really great solutions
Like I said in the first reply I think arrays crunch BIG data fast, but I could be wrong, so... But I would be looking at the formulas that you using. It wouldnt hurt to see if they guys in the Formula Forum might know of a more efficient algorithm for what youre doing. Until you provide sample data its just stabs in the dark.
VBA is not always the fastest way to do things that’s why I keep mentioning formulas, but I don’t know what Im talking about either, thats why I come here & ask questions but only when I am absolutely stuck.
Lastly I don’t do this:
I do it with cells like this:
I do believe its more efficient [Find being faster than count], again I could be totally wrong on that.
Bookmarks