Excel Tip Which Of My Scores Is In 3rd Position Use Excel Large Formula
visibility
1M views
calendar_month
Nov 6, 2022
Read the blog post to this video here http://www.howtoexcelatexcel.com/formulas/formula-friday-find-the-k-th-largest-value-in-your-excel-data-set-using-the-large-function/
Do you want become an expert in Excel?. Then take a look at Mynda Treacy's Excel Expert course. The Link is here..http://www.mothresource.com/152-8-3-11.html
Download the example Excel workbook to this video here http://www.howtoexcelatexcel.com/formulas/formula-friday-find-the-k-th-largest-value-in-your-excel-data-set-using-the-large-function/
------------------------------------------------------------------
****SUBSCRIBE****** to my Excel at Excel newsletter 3 FREE Excel Tips every 15 days http://www.howtoexcelatexcel.com
-------------------------------------------------------------------
Website http://www.howtoexcelatexcel.excel.com
Twitter https://twitter.com/howtoexcelatex
Pinterest http://www.pinterest.com/howtoexcelat
--------------------------------------------------------------------
Today let’s look at the LARGE function in Excel. It is a really handy one that will easily allow us to select a value based on it’s relative standing in your data set. For example to find the highest, runner up or 3rd place value in a a list of numbers.
=LARGE(ARRAY,K)
Where ARRAY = the range of cells that contains the data to be used in the function.
K= the Kth largest value such a the 3rd that is being south from the data.
See how easy it is to use the LARGE formula.
Show More keyboard_arrow_down
Show Lesskeyboard_arrow_up