![]() For example, you can use MMULT with XLOOKUP to match a value in any column. The MMULT function appears in certain more advanced formulas that need to process multiple rows or columns. The result from MMULT is an array that contains the same number of rows as array1 and the same number of columns as array2. ![]() The MMULT function returns the matrix product of two arrays, sometimes called the "dot product".
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |