Hi i need to drag down a matrix formula and increase one value
This is my formula:
{=MAX(($Compras.C6:$Compras.C2500=B6)*($Compras.D6:$Compras.D2500))}
When i drag down to copy that formula to de nex cell y need to increase B6 to B7 and the B8 … automaticale
is it possible to do that?
Thanks!
You can use the aggregate function for this. This is automatically an array function. With parameter 4 you also reach the MAX() function.
=AGGREGATE(4,0,($Compras.C$6:$Compras.C$2500=B6)*($Compras.D$6:$Compras.D$2500))
Then you can copy the formula down for B7 etc.
S U P E R B
THANKS dscheikey !!!