Excel Tip Which Of My Scores Is In 3rd Position Use Excel Large Formula

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.