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

Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. 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