Add up the quantities of numbers present in each letter in column
Numbers 41 and 42 do not enter
https://www.excelforum.com/attachmen...1&d=1525269811
Add up the quantities of numbers present in each letter in column
Numbers 41 and 42 do not enter
https://www.excelforum.com/attachmen...1&d=1525269811
Maybe start with this and work from there.
Please Login or Register to view this content.
hello DAVE,, this is correct, but you have to do all the draw lines! only ten have been done, have to do all
has to do all inclusive when I will update new raffles the macro has to do automatic
Ya, I suppose there is a better way to do this, I can't think of it right now, I'll see if others can pitch in.
Okay, and the other draw lines?
Try below. Takes about 19 to 20 sec on my machine to run.
Please Login or Register to view this content.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Hmm, come to think of it. It might be faster to use logic rather than loop on luA array.
If others haven’t chimed in, I’ll take another look tomorrow.
Hello,CK76 oh, yes this correct perfect work, congratulations,
Maybe a little faster the macro, but this is good
u may try using the array formula,
in P5:
Formula:Please Login or Register to view this content.
use Crtl + Shift + Enter instead Enter only.
{} will incurred if it is an array formula, manual put in will not effected.
then copy to S5 and drag down to end.
Hope you can learn every time you visit here.
If you still confuse on how it work, kindly ask or go to
i) Formula - Formula (Ribbon) > Formula Auditing (Section) > Evaluate Formula > Evaluate; or
ii) VBA/Code - Click F8 to see how it work step by step.
It it take care of your question, Please:
Mark tread as [Solved] [Thread Tools->Mark thread as Solved];and
Click *Add Reputation to thank anyone solved your question.
Yep, I think for this sort of calculation, formula is well suited.
No need to commit multiple array into memory and requires less loop.
This version should take less than 1 sec (0.2 sec ~ 0.4sec).
Edit: Made slight modification to code. Now completes in around 0.16 sec on my machine.Please Login or Register to view this content.
Last edited by CK76; 05-03-2018 at 09:55 AM. Reason: See Edit:
Hello DR76 huu Spectacular execution time !, Congratulations, conglatulations
* Very good job, thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks