Should be there soon.
Have you tried the solution offered here?
http://www.ozgrid.com/forum/showthre...d=1#post523641
It is very good but I don't think it is quite there, the hour results are incomplete.
My code is much slower but it returns much more information, for each hour and day.
Please let me know if you are going Robs' way.
How are Retries defined, are they always ... RETRY/3
or is it this way RETRY/1, RETRY/2, RETRY/3, etc. this can affect the execution time considerably.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
hi, I dont know what to do with Robs code, I dont know how to insert it?
No, they are always RETRY/3, but want I want to count is the number of times, this happens for each serial, so I want to then produce a pie chart showing
1 retry- number of serials it happened for?
2 retries- number of serials it happened for?
3 retries- number of serials it happened for?
I can send you the full spreadsheet with nearly 600,000 entries if that would be easier
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
darrenb 
Register To Reply
Bookmarks