The result from MMULT is anarraythat contains the same number of rows asarray1and the same number of columns asarray2.

COLUMN Function

The Excel COLUMN function returns the column number for a reference.

For example, COLUMN(C5) returns 3, since C is the third column in the spreadsheet.

Excel formula: Count rows with multiple OR criteria

When no reference is provided, COLUMN returns the column number of the cell which contains the formula.

Excel formula: Count if row meets internal criteria

Excel formula: Count if row meets multiple criteria

Excel formula: Count rows that contain specific values

Excel MMULT function

Excel COLUMN function

Excel TRANSPOSE function