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

Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X

Identify variable with maximum value

ppal
17-Peridot

Identify variable with maximum value

ppal_0-1720586505506.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Werner_E
24-Ruby V
(To:ppal)

You may also omit the "augment" function in "max" when using Luc's solution.

Werner_E_0-1720602862400.png

 

Depending on which way you need the result, you may turn it into a function.
Unfortunately there is no way we could automatically access the name of a variable.

Werner_E_1-1720602943366.png

 

Prime 10 sheet attached

 

View solution in original post

4 REPLIES 4
LucMeekes
23-Emerald III
(To:ppal)

Use

match( max( augment( A, B, C)), augment( A, B, C))

And inspect the vector of results.

 

Update:

See attachment

 

Success!

Luc

MartinHanak
24-Ruby II
(To:ppal)

Hi,

I was curious and tried Luc's solution.

MartinHanak_1-1720595413224.png

 

 


Martin Hanák
Werner_E
24-Ruby V
(To:ppal)

You may also omit the "augment" function in "max" when using Luc's solution.

Werner_E_0-1720602862400.png

 

Depending on which way you need the result, you may turn it into a function.
Unfortunately there is no way we could automatically access the name of a variable.

Werner_E_1-1720602943366.png

 

Prime 10 sheet attached

 

Hello @ppal

 

It looks like you have some responses from some community members. If any of these replies helped you solve your question please mark the appropriate reply as the Accepted Solution. 

Of course, if you have more to share on your issue, please let the Community know so other community members can continue to help you.

Thanks,
Vivek N.
Community Moderation Team.

Top Tags