The RANK function lets you rank a value compared with other values in a range based either on a highest-to-lowest (the default setting) or lowest-to-highest arrangement. Two or more entries share the same ranking position if their values are identical, but the ranking numbers that follow will not appear.
- [Voiceover] We are looking at a worksheet called RANK.…And we've got some data over in columns A and B,…employee name and salary.…We like to know the rank of each salary here compared…with all of the others.…And we might want to eventually want to add more…data to this list.…Although we could sort the data to get these results,…why not have the numbers right here all the time.…In other words if we sorted by salary, by employee name,…we always want to see that ranking.…Equal, rank, left parenthesis, here's the number we are…talking about, comma, we are comparing with all of the…others in column B.…
There is nothing else in column B except that text…on top and these numbers.…We will have an answer immediately…and that is from top down.…This is the 71 highest salary.…As I double click to copy this down the column,…you might notice, perhaps right away, two of these are tied.…These are tied for second place here.…Scrolling up and down this list of about 100 names we will…not see a number three in here.…Possibly there could be three number twos, we don't…
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
-
Welcome46s
-
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: Rank data without sorting using the RANK function