View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.programming
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default Sorting by month

Hello Eric,

Thanks for your feedback.

For 5 columns the macro does not need to be changed. Just change the
call to the macro:
=Sfreq(A1:A99,B1:B99,C1:C99,D1:D99,E1:E99)
[array-entered again, please keep in mind that the last entered column
is containing the VALUES you want to sum up.]

If you have many rows (tens of thousands) let me optimize the memory
strategy first. With less it should work fine.

Regards,
Bernd