Imagine I have a matrix in Excel, i.e., an array in the interval A1:E5. Each cell has either a 0 or a 1. How can I find the position of a random zero in that array?
I saw that using the Excel function SUMPRODUCT, I would be able to find the row and column to which a certain value corresponded. The problem is that this procedure would only work if the value I was looking for was unique.
Here's an example of what I want:
Consider that my data is
I would like to have a function that would select a random output from the set
By function I mean an expression in an Excel cell.
Anyone knows how to do this?