Skip to main content
Werner_E
Werner_EAnswer
25-Diamond I
July 10, 2024

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 in thread

4 replies

LucMeekes23-Emerald IV
23-Emerald IV
July 10, 2024

Use

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

And inspect the vector of results.

 

Update:

See attachment

 

Success!

Luc

Translate
    MartinHanak24-Ruby III
    24-Ruby III
    July 10, 2024

    Hi,

    I was curious and tried Luc's solution.

    MartinHanak_1-1720595413224.png

     

     

    Translate
    Werner_E
    Werner_E25-Diamond IAnswer
    25-Diamond I
    July 10, 2024

    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

     

    Translate
    vnamboodheriCommunity Manager
    Community Moderator
    July 17, 2024

    Hello @ppal_205706, 

     

    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.

    Translate
    Terms & ConditionsAccessibility statement