array formula doesnt work from row 32737

  • Thread starter Thread starter thread
  • Start date Start date
T

thread

Hi
i'm using "array" formula in my excel macro and from some reason the
excel cannot populate the formula above 32737 rows,is there an option
to overcome this problem?
 
Hi,

Seeing the macro would have been helpful but my guess is you may mean 32,767
and this may be because you have a variable incorrectly Dimensioned as
integer. Dimension as long instead.

Mike
 
Try adding to arrays =sum(if(a1=a1:a32000,1,0))+sum(if(a1=a32001:a65535,1,0))

cntrl+shift+enter
 
this is one of the formulas
=IF(AE32737="","",IF(VLOOKUP(I32737,'AMR %'!J:AB,6,0)>0,VLOOKUP
(I32737,'AMR %'!J:AB,6,0)*9-4,INDEX(Definitions!$E$24:$E$273,MATCH(1,
(AE32737>=Definitions!$C$24:$C$273)*(AE32737<=Definitions!$D$24:$D
$273),0))))
and the last in line
 
Back
Top