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

Identify variable with maximum value

ppal
17-Peridot

Identify variable with maximum value

ppal_0-1720586505506.png

 

ACCEPTED SOLUTION

Accepted Solutions
Werner_E
25-Diamond I
(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 III
(To:ppal)

Hi,

I was curious and tried Luc's solution.

MartinHanak_1-1720595413224.png

 

 


Martin Hanák
Werner_E
25-Diamond I
(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.

Announcements

Top Tags