I want to output 4 group parameter's FREQUENCY from large table, EXCEL structure as below:
Parameter1 array range{=FREQUENCY(L4503,B4:B100)+FREQUENCY(P4503,B4:B100)+...+FREQUENCY(BYF4:BYF503,B4:B100)}
Parameter2 array range{=FREQUENCY(M4:M503,B4:B100)+FREQUENCY(Q4503,B4:B100)+...+FREQUENCY(BYG4:BYG503,B4:B100)}
Parameter3 array range...
Parameter4 array range...
There are too long (500x4 col.) formula cannot excutive on cell, how to solve if using by VBA???
Bookmarks