Excel equations
BracketIndexMatch |
Example of Bracket Equation
=IFERROR(INDEX(Pvt!$G1:$Z$5000,MATCH($F$3&$H5,Pvt!$A1:$A$5000&Pvt!$F1:$F$5000,0),MATCH(I$4,Pvt!$G$1:$Z$1,0)),"-")
DefineRange Equation |
Range OffSet for Dynamic Range
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1))