Hi
I have two groups of lottery results. The first group has the last year results of 200 rows, and the second group displays this year results of 100 rows. I want to start comparing the first row of the second group (green group) with all the rows of the first group( blue group) giving me a count of how many matches are found.. And do the same search for all the other rows of green group…
Please have a look at the attachment file.
Thank you.
Hi gencoglu27
I think the attached achieves what you requested.
When you win the millions using this, please remember who sent it to you
Let me know if you have any questions
Regards
Alastair
Thank you very much indeed,
I thought that my post was bad one and it would not be answered.But you managed to answer it just as I wish. Your code works nice.
the only problem is that it is a little bit too slow
. Actually I have more than 10.000 rows and I want it to work faster.. Still I wil play with it..
Thanks,
Last edited by gencoglu27; 07-20-2013 at 04:33 PM.
Hi gencoglu27
Answer - get a faster machine!
On a more serious note the VBA has been written specifically for 200 lines. Are you OK with how to change it?
One thing that can be done to speed things up is to turn off screen updating while the VBA is running. The downside of this is that it looks like nothing is happening for however long it takes to run. Again - are you ok with how to make the change, or do you want me to do it?
Regards
Alastair
Thanks Alastair,
Actually my Pc is fast enough .For example it can generate 270.000 lines of lottery combination in less than 3 minutes.. Now I attached another file of 1,000 of lines in which I changed my question so it may work faster.( I would like you to omit the columns of 1 match,2 matches and 3 matches) please have a look at it.( but wait I can not manage the attachments as it says it is 1.58MB !!!)...So how can I send my file to you ?
my computer has AMD athlon2 proccesor 4 core ..4GB Ram..
Thanks
Last edited by gencoglu27; 07-22-2013 at 05:46 AM.
Hello
I am coming in at the end but took this problem as an exercise and spent the occasional spare hour or 2. So I have not looked at the code that was referred but created my own solution. It should managed a dynamic length of numbers.
Perhaps give it a try and see if it improves on the performance of the other solution.
Regards
Most helpful to mark solved items as such (see help for directions). Star ratings are always welcome.
Thanks Hamjam,
I have just tested your code. It works ok. But when it comes to comparing 10.000 lines to 600 lines ..(which is I am after..), your code is even slower than that ofaydeegee. see if you can make it faster ?
thanks a lot.
Hello
In principal you need to put more of the information into RAM memory to speed it up. You could play around with feeding the target values into an array and then doing the finding in memory.
Regards
Hi gencoglu27
I have made the changes that I suggested. On 14,000 lines it takes 6 seconds to do 100 comparisons (hence 1 minute to do 1000)
File attached, but most of the 14,000 removed!
Regards
Alastair
Hi aydeegee,
Thank you very much indeed. that's exactly what I need. You did it and saved the day.
I tested your code and pasted 14.000 lines and compared it to 600 comparisons . It took only less than 30 seconds which is very nice..
Hi gencoglu27
.... almost forgot. When you have your big win - remember who provided the code!
Regards
Alastair
Hi gencoglu27
Glad it worked for you.
Regards
Alastair
Re: comparing the rows in different columns and displaying the results
Ok...Be sure you will be the first person I will share the treasure with....
Hello to Eastbourne..
Take care
Regards
Gencoglu
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
gencoglu27 
Register To Reply
Bookmarks