Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
Sheets Tip 350: Where does my score rank?
|
Brought to you by:
Welcome to the Google Sheets Tips newsletter #350, your Monday morning espresso, in spreadsheet form! I'm happy to report that I'm feeling a lot better now than I did this time last week. Thanks to modern medicine and plenty of rest, I'm well on my way back to normal (whatever that is these days!). Thanks to the many of you who sent well wishes, it was very much appreciated 🙏. ➜ NewsI. Read more in the Workspace Updates Recap >> ➜ Sheets Tip #350: How to use the RANK function to determine ranking positionSuppose Sophia recently took an exam and scored a highly respectable 83%. Her teacher wants to know how she fared in relation to her fellow students who took the same exam. The teacher uses the RANK function to do this: =RANK( 83 , A2:A101 ) where "83" is the result to be ranked, and A2:A101 is the range of possible scores. It gives a result of 21 in this example. In other words, Sophia's score of 83% placed her 21st out of 100 students who took this exam. Not bad! Note: The value to be ranked must be present within the data range, otherwise the formula returns a #N/A error. Ascending or Descending Data?There is an optional third argument for the RANK function. It determines whether to consider the data as ascending (e.g. 100 is the best score, 0 the worst score) or descending (e.g. 0 is the best score, 100 is the worst score). E.g. in our example, 100 is the best score and 0 the worst score. If this third argument is set to 0, then the data is ascending. If it's set to 1, it's descending. (And if we omit the third argument, the function defaults to the ascending option.) However, to be really explicit, we could have written the formula like this: =RANK( 83 , A2:A101, 0 ) If you enjoyed this newsletter, please forward it to a friend who might enjoy it. Have a great week! Cheers, |
Google Sheets Tips
Get better at working with Google Sheets! Join 50,000 readers to get an actionable tip in your inbox every Monday.
Brought to you by: Hi Reader, After a few weeks break for the summer 🏖️, we're back with the Google Sheets Tips newsletter #355, your Monday morning espresso, in spreadsheet form! What's new? AI continues to dominate the tech headlines, with new features crammed into every corner of the internet, whether they’re needed or not. But beyond the hype, the tools are improving, and that includes in the spreadsheet domain. These days, when I need to create a complex formula, I often start with a...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #354, your Monday morning espresso, in spreadsheet form! In last week's newsletter we compared wide and tall data, and what the pros and cons of each data "shape" were. Today, I want to show you how to move from one format to the other. How to transform tall data into wide data and vice versa. Going in one direction is easy. Going back, in the other direction, is less so. Find out which way round below! ➜ News I. It's...
Brought to you by: Hi Reader, Welcome to the Google Sheets Tips newsletter #353, your Monday morning espresso, in spreadsheet form! Today we're looking at the shape of data. It's foundational concept that underpins pivot tables and charts in Google Sheets. Once you understand the difference between wide data (for charts) and tall data (for pivot tables), you'll be off to the races! This week is all about the pros and cons of each data shape. Next week, I'll show you how to use formulas and...