Hi everyone!
I have stumbled upon a problem while trying to extract the address of the formula's result. Namely, I am talking about the formula that calculated minimum value from the matrix based on the different criteria.
The matrix that I have created is simplified just for the purpose of this question.
<tbody>
</tbody>
**
If the "FORMULA" = 44, I would like to know the exact position of this result (the one bolded in the matrix)
So far I have tried CELL("address" but id doesn't seem to work because my formula is MIN(IF array formula.
I would appreciate any ideas or solutions.
I have stumbled upon a problem while trying to extract the address of the formula's result. Namely, I am talking about the formula that calculated minimum value from the matrix based on the different criteria.
The matrix that I have created is simplified just for the purpose of this question.
V. Criteria 1 | V. Criteria 2 | V. Criteria 3 | |
H. Criteria 1 | 22 | 33 | 44 |
H. Criteria 2 | 22 | 33 | 55 |
H. Criteria 3 | 25 | 44 | 11 |
<tbody>
</tbody>
**
If the "FORMULA" = 44, I would like to know the exact position of this result (the one bolded in the matrix)
So far I have tried CELL("address" but id doesn't seem to work because my formula is MIN(IF array formula.
I would appreciate any ideas or solutions.