{"id":3461,"date":"2014-03-04T16:08:19","date_gmt":"2014-03-04T10:38:19","guid":{"rendered":"http:\/\/trumpexcel.com\/?page_id=3461"},"modified":"2023-11-17T15:34:04","modified_gmt":"2023-11-17T10:04:04","slug":"excel-large-function","status":"publish","type":"post","link":"https:\/\/trumpexcel.com\/excel-large-function\/","title":{"rendered":"How to Use Excel LARGE Function (Examples + Video)"},"content":{"rendered":"

Excel LARGE Function (Example + Video)<\/span><\/h2>\n

\"Excel<\/p>\n

When to use Excel LARGE Function<\/span><\/h3>\n

Excel LARGE function can be used to get the Kth largest value from a range of cells or array. For example, you can get the 3rd largest value from a range of cells.<\/p>\n

What it Returns<\/span><\/h3>\n

It returns the value which\u00a0is the Kth largest value from a range of cells.<\/p>\n

Syntax<\/span><\/h3>\n

=LARGE(array, k)<\/p>\n

Input Arguments<\/span><\/h3>\n
    \n
  • array – the array or range of cells from which you want to fetch the kth largest value.<\/li>\n
  • k – the rank or position (from the top) of number that you want to fetch.<\/li>\n<\/ul>\n

    Additional Notes<\/span><\/h3>\n
      \n
    • If array is empty, LARGE returns the #NUM! error value.<\/li>\n
    • If k \u2264 0 or if k is greater than the number of data points, LARGE returns the #NUM! error value.<\/li>\n
    • If n is the number of data points in a range, then LARGE(array,1) returns the largest value, and LARGE(array,n) returns the smallest value.<\/li>\n<\/ul>\n

      Examples \u2013 Excel LARGE Function<\/span><\/h2>\n

      Here are six example of using Excel LARGE Function:<\/p>\n

      #1 Getting the largest value from a list<\/strong><\/span><\/h3>\n

      \"Excel<\/p>\n

      If you have a list of numbers (A2:A4) and you want to get the largest number from the list, you can use the following LARGE function: =LARGE(A2:A4,1)<\/p>\n

      Here the Kth value is 1, which would return the largest number from the range of numbers.<\/p>\n

      #2 Getting the second largest value from a list<\/strong><\/span><\/h3>\n

      \"Excel<\/p>\n

      To get the second largest value from the list (A2:A4), use the following formula: =LARGE(A2:A4,2)<\/p>\n

      Since the Kth value in the formula is 2, it returns the second largest values from the range of numbers.<\/p>\n

      #3 Using LARGE function when there are blank cells in the range<\/strong><\/span><\/h3>\n

      \"Excel<\/p>\n

      If there are any blank cells in the range, it is ignored by the LARGE function.<\/p>\n

      For example, in the above example, while we take the range of cells as A2:A5, the blank cell is ignored by the LARGE function while returning the largest value from this list.<\/p>\n

      #4 Using LARGE function when there are cells with text<\/strong><\/span><\/h3>\n

      \"Excel<\/p>\n

      Similar to blank cells, Excel LARGE function also ignores cells with text, alphanumeric characters, special characters, and logical values.<\/p>\n

      #5 Using LARGE function when there are cells with duplicates<\/strong><\/span><\/h3>\n

      \"Excel<\/p>\n

      If there are duplicates in the range used in the LARGE function, it will treat those duplicates as consecutive values. In the above example, two cells have the value 7. Now when you use LARGE function to return the largest and second largest value, it returns 7 in both the cases.<\/p>\n

      #6 Using LARGE function when there is Error in the cells<\/strong><\/span><\/h3>\n

      \"Excel<\/p>\n

      If there is an error in any of the cells used in the LARGE function, it will return an error.<\/p>\n

      Excel LARGE Function – Video Tutorial<\/span><\/h2>\n