cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X

Select and match

ldante
11-Garnet

Select and match

Hi

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

1 ACCEPTED SOLUTION

Accepted Solutions
ViktorKorobov
13-Aquamarine
(To:ldante)

5 REPLIES 5

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

ViktorKorobov
13-Aquamarine
(To:ldante)

match.png

Viktor

Viktor

thanks

Top Tags