Is there any way to get have VBA enter the following array in a cell even though it is above the 255 character limit?
=SUM(IF(FREQUENCY(IF((AN2:AN1021<=100)*(AN2:AN1021<>""),ROW(AN2:AN1021)),IF(AN2:AN1021>100,ROW(AN2:AN1021)))>=10,1))
I tried using a workaround posted here:
http://dailydoseofexcel.com/archives...rmulas-in-vba/
but could not get it to work
Thanks in advance
Bookmarks