Top x values

  • Resolved mpbaweb

    (@mpbaweb)


    2 months ago

    Hi I have several tables where the last column is a sum of all the numeric values in the preceding 7 columns. I actually want to be able to return the sum of the top(x) values. Usually this will be the 5 largest values. Is there a formula available like Excel “LARGE()”?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    2 months ago

    Hi,

    Thanks for your question!

    Yes, the LARGE function from Excel is available in TablePress, so that should work well here.

    Best wishes,
    Tobias

    Thread Starter mpbaweb

    (@mpbaweb)

    2 months ago

    Thanks!

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    2 months ago

    Hi,

    no problem, you are very welcome! 🙂 Good to hear that this helped!

    Best wishes,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.