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

Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! 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 ?

ACCEPTED SOLUTION

Accepted Solutions
ViktorKorobov
14-Alexandrite
(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
14-Alexandrite
(To:ldante)

match.png

Viktor

Viktor

thanks

Announcements

Top Tags