View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default Counting unique numbers

Hello Lori,

400,000 records are admittedly asking for a database approach.

I optimized the memory strategy of my UDF Pfreq and its working now
for 65,536 rows with 10,000 different items. Runtime on my dualcore
proc: about 6 seconds.

Regards,
Bernd