-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
mmult function
-
S
Modifying complex formula: Adding a condition
A while back, I received some phenomenal help from Nishant94 regarding a complex formula I was trying to build to capture unique number of overlap days based upon some criteria. The original thread is here: Count Number of Unique Overlap Days - Meeting Criteria The formula (CSE) is this...- spydey
- Thread
- criteria formula formula and if mmult function unique cells
- Replies: 2
- Forum: Excel Questions
-
K
Array formula to calculate sum product of every combination of rows from 2 ranges
I have 2 ranges with different number of rows but same number of columns, for example: Range1 = A1:Z10 =10 rows x 26 columns Range2 = A11:Z30 = 20 rows x 26 columns Now I need an array formula of 20 rows x 10 columns, which gives the sum product of every combination of rows from these two...- Kelvin Stott
- Thread
- array formula mmult function rows sumproduct transpose
- Replies: 9
- Forum: Excel Questions
-
L
How to Create Function for Matrix Multiplication
Hi, I have some problem with function of MMULT in excel. I want to do sample two matrix multiplication by MMULT function. X matrix at a given interval and k is a function that multiplies the matrix for the value of the number. Many thanks for your help. Example: Selected cells in the range...- lehrymut14
- Thread
- matrix function matrix multiplications mmult function
- Replies: 2
- Forum: Excel Questions
