Return Column and Row Vales for the minimum value in the table Hi - I am trying to find a formula that will return the correct column and row for the minimum value in a table..
For example - in the below table I would want to type in a formula that gives me the column (x) and the row (c) for the minimum value. I am okay with these being separate functions fo...Hi - I am trying to find a formula that will return the correct column and row for the minimum value in a table..
For example - in the below table I would want to type in a formula that gives me the column (x) and the row (c) for the minimum value. I am okay with these being separate functions for row and column
x y z
a 7 8 9
b 6 6 5
c 2 9 4Read More
Hi - I am trying to find a formula that will return the correct column and row for the minimum value in a table.. For example - in the below table I would want to type in a formula that gives me the column (x) and the row (c) for the minimum value. I am okay with these being separate functions fo... Hi - I am trying to find a formula that will return the correct column and row for the minimum value in a table..
For example - in the below table I would want to type in a formula that gives me the column (x) and the row (c) for the minimum value. I am okay with these being separate functions for row and column
x y z
a 7 8 9
b 6 6 5
c 2 9 4 Read More