Skip to main content
L
ldante11-Garnet
11-Garnet
June 14, 2017
Solved

Select and match

  • June 14, 2017
  • 5 replies
  • 1982 views

Hi

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

Best answer by ViktorKorobov

match.png

Viktor

5 replies

V
ValeryOchkov24-Ruby IV
24-Ruby IV
June 14, 2017

L
ldante11-GarnetAuthor
11-Garnet
June 14, 2017

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 .

V
ViktorKorobov1-VisitorAnswer
1-Visitor
June 14, 2017

match.png

Viktor

L
ldante11-GarnetAuthor
11-Garnet
June 14, 2017

thanks

Terms & ConditionsAccessibility statement