Skip to main content
Werner_E
Werner_EAnswer
25-Diamond I
Jul 10, 2024 9:16 AM UTC

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 V
23-Emerald V
Jul 10, 2024 5:19 AM UTC

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
    Jul 10, 2024 7:10 AM UTC

    Hi,

    I was curious and tried Luc's solution.

    MartinHanak_1-1720595413224.png

     

     

    Translate
    Werner_E
    Werner_E25-Diamond IAnswer
    25-Diamond I
    Jul 10, 2024 9:16 AM UTC

    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
    Jul 17, 2024 4:57 AM UTC

    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