On 2002-02-21 13:50, DaKen wrote:
This process is working, but it crashes or nearly crashes the program. I have almost 10,000 records in the array. Is there a different way to get the info?
DaKen,
Yes, the array-formula that I gave you copied to 10,000 cells or more will be a pain performancewise, as you observed. I have a different proposal, again formula-based. This proposal trades memory against speed. I'm curious about how it performs ( I don't have 10,000 records to check its performance
)
I still assume our sample data in A1:C7. That is:
{"Dates","Acc Nums";37258,"acc1";37258,"acc2";37258,"acc1";37289,"acc3";37289,"acc3";37317,"acc1"}
And unique dates in D2:D4, that is:
{37258;37289;37317}
In E2 enter:
="B"&MATCH(D2,A:A,0)&":"&"B"&MATCH(IF(D3,D3,D2),A:A,0)-IF(D3,1,0)
Copy down this as far as needed.
In F2 enter:
=SUM(IF(FREQUENCY(MATCH(INDIRECT(E2),INDIRECT(E2),0),MATCH(INDIRECT(E2),INDIRECT(E2),0))>0,1))
Copy down this as far as needed.
Caveat. I assume that the data are sorted on dates.
Note that there are NO formulas here that need to be array-entered.
What you get to see in D:F is:
{37258,"B2:B4",2;
37289,"B5:B6",1;
37317,"B7:B7",1}
Aladin