Title: Using the LARGE() function
Last modified: September 14, 2026

---

# Using the LARGE() function

 *  Resolved [mpbaweb](https://wordpress.org/support/users/mpbaweb/)
 * (@mpbaweb)
 * [1 week, 1 day ago](https://wordpress.org/support/topic/using-the-large-function/)
 * Hi – I want to find the 3 largest values in columns G to N of my table but I 
   specifically want to EXCLUDE columns J and L, so my final formula is [ Col J 
   + Col L ]+[ (3 largest values in Cols G,H,I,K,M,N) ]. Is this possible?

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

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [1 week, 1 day ago](https://wordpress.org/support/topic/using-the-large-function/#post-19019998)
 * Hi [@mpbaweb](https://wordpress.org/support/users/mpbaweb/),
 * Thanks for your question, I’ll be happy to help!
 * Now, this is more a question around Excel formulas, and I think this might work(
   not tested):
 * Largest value:
 *     ```wp-block-code
       =LARGE( CHOOSECOLS( G1:N1000, 1, 2, 3, 5, 7, 8 ), 1 )
       ```
   
 * 2nd-largest values:
 *     ```wp-block-code
       =LARGE( CHOOSECOLS( G1:N1000, 1, 2, 3, 5, 7, 8 ), 2 )
       ```
   
 * 3rd-largest value:
 *     ```wp-block-code
       =LARGE( CHOOSECOLS( G1:N1000, 1, 2, 3, 5, 7, 8 ), 3 )
       ```
   
 * This is based on Excel’s [LARGE](https://support.microsoft.com/en-us/excel/functions/large-function)
   and [CHOOSECOLS](https://support.microsoft.com/en-us/excel/functions/choosecols-function)
   functions.
 * Best wishes,
   Tobias
 *  Thread Starter [mpbaweb](https://wordpress.org/support/users/mpbaweb/)
 * (@mpbaweb)
 * [1 week ago](https://wordpress.org/support/topic/using-the-large-function/#post-19020290)
 * Thank you!
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [1 week ago](https://wordpress.org/support/topic/using-the-large-function/#post-19020367)
 * 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](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fusing-the-large-function%2F%3Foutput_format%3Dmd&locale=en_US)
to reply to this topic.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [1 week ago](https://wordpress.org/support/topic/using-the-large-function/#post-19020367)
 * Status: resolved