How can I select the maximum number in each column from (m) but not more than 1 and match this in the "match ?
Solved! Go to Solution.
The conditions are
Select the maximum number in each column but not more than 1
then lookup (row(match))
Sorry if my explanation is not technical sound as a programmer .