cancel
Showing results for 
Search instead for 
Did you mean: 
Security Alert Log4j Security Vulnerability. Click here to know more.
cancel
Showing results for 
Search instead for 
Did you mean: 

Select and match

ldante
10-Marble

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)

thanks

Announcements
Check out the latest
Mathcad Tip
"PTC Mathcad 15 / Prime 1-6 Update."