The LARGE function returns the second (or third, fourth, fifth, etc.) largest value in a selected range. The SMALL function returns the second (or third, fourth, fifth, etc.) smallest value in a selected range. Neither function provides the location of the result, simply the value of the result.
- [Voiceover] On the worksheet called Large,…we've got some data in columns A through F.…If I click on one of the cells,…in column A for example,…double click the bottom edge,…a quick reminder, we've got 401 rows of data here.…And off to the right in column J,…I've got some words indicating what it is I need to get to…relatively quickly.…This list may grow, it might shrink,…so when I use formulas here,…I will be referring to entire columns.…I want to know what the highest salary is,…it's in column E.…I use the function Max, right here in cell I2.…Equal max, left parentheses.…
Since the list will grow,…I'll use an entire column reference.…There it is.…Don't need to press the right parentheses.…Return, there it is.…Sometimes you want to know the second highest,…third highest.…The function is called Large.…So, where are we looking?…Once again, in column E, comma.…And now we put in the number that we're interested in.…I'm interested in finding the second highest.…I'll put in the number two,…third highest three and so on.…
Author
Dennis Taylor
Released
5/26/2016- Understanding how the hierarchy of operators affects formula results
- Knowing when to use absolute vs. relative references
- Using Formula Builder for unfamiliar functions
- Displaying a worksheet's formulas and highlighting formula cells
- Converting formulas to values
- Creating 3D formulas to gather data from multiple sheets
- Creating and expanding nested IF functions; using AND, OR, and NOT with IF
- Looking up information with VLOOKUP, HLOOKUP, MATCH, and INDEX
- Analyzing data with the statistical functions: MEDIAN, MODE, etc.
- Using the power functions: COUNTIF, SUMIF, COUNTIFS, AVERAGEIFS, and more
- Calculating financial data such as payments
- Performing basic math
- Calculating dates and times
- Editing text with functions
- Using array formulas and functions
- Referencing data in other cells and files
- Extracting information from Excel worksheets
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome50s
-
Exercise files25s
-
-
1. Formula and Function Tools
-
2. Formula and Function Tips and Shortcuts
-
3. IF and Related Functions
-
4. Lookup and Reference Functions
-
Use MATCH and INDEX together4m 40s
-
5. Statistical Functions
-
6. Power Functions
-
7. Selected Financial Functions
-
8. Math Functions
-
9. Date and Time Functions
-
10. Text Functions
-
11. Array Formulas and Functions
-
12. Reference Functions
-
13. Information Functions
-
Conclusion
-
Next steps25s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Find largest and smallest values with LARGE and SMALL