Select and match

[ldante]

Hi

How can I select the maximum number  in each column from (m) but  not more than 1  and match this in the "match ?

[ValeryOchkov]

[ldante]

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 .

[ldante]

Result should be

[ViktorKorobov · Accepted solution]

Viktor

[ldante]

thanks