25th May 2006, 02:55 PM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 4,432
|
|
Quote:
|
Originally Posted by Chinbok
Only problem is how long it takes - a couple of minutes to process 1 month.
Cheers
|
Mate, that's a luxury, when I first started doing rankings in Excel 6 years ago, some "bright spark" told me to do a sumproduct and array calculation which took more than 8 hours for a few months data!!!
It only dawned on me later that a simple sort and rank formula would take less than a few minutes - and that was the copy and paste time 
 |