Skip to main content
T
TA_102064008-Gravel
8-Gravel
April 23, 2023
Solved

Max value of columns/rows

  • April 23, 2023
  • 1 reply
  • 4619 views

Is there a way to find max values for two columns, outputted as one column in prime 9? 

 

 

 

Best answer by LucMeekes

There are at least two ways to accomplish what you want, on worksheet level and by using a function. Both are shown in the attached worksheet.

 

Success!
Luc

1 reply

W
Werner_E25-Diamond I
25-Diamond I
April 23, 2023

There sure is a way to do what you are asking for, but its not clear to me what exactly you need.

Best you provide some samples in a worksheet, state what result you are expecting and attach the sheet here.

What I understood from your short question was, that you want to find the maximum of the first and the maximum of the second vector and want the two values returned in a 2 x 1 vector.

Could be done that way:

Werner_E_1-1682291502231.png

P9 worksheet attached

 

T
TA_102064008-GravelAuthor
8-Gravel
April 24, 2023

Skjermbilde 2023-04-24 kl. 20.53.17.pngHi Werner, thank you for you're reply.

 

I've attached my worksheet, with a workaround solution I created to solve this issue. The attached image is from the second page.

 

Thanks

L
LucMeekes23-Emerald IVAnswer
23-Emerald IV
April 24, 2023

There are at least two ways to accomplish what you want, on worksheet level and by using a function. Both are shown in the attached worksheet.

 

Success!
Luc

    Terms & ConditionsAccessibility statement