array formula doesnt work from row 32737

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?
 
M

Mike H

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
 
G

galimi

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

cntrl+shift+enter
 
T

thread

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
 
Top