Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X
Hi
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 .
Result should be
Viktor
thanks