Skip to main content
Best answer by Werner_E

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

 

4 replies

L
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

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

    Hi,

    I was curious and tried Luc's solution.

    MartinHanak_1-1720595413224.png

     

     

    W
    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

     

    V
    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.

    Terms & ConditionsAccessibility statement