Brought to you by:

Hi Reader,

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 🙏.

➜ News

I.
​Google are adding a new setting to Google Forms to allow form responders to contact form owners.

​Read more in the Workspace Updates Recap >>​

Brought to you by: Kirksville Web Design Premium Google Sites Templates 60+ awesome templates available for business websites, online portfolios and resumes. Google Sites is a no-code site builder with free hosting in Google Drive. Drag and drop your content into professionally designed themes, connect your own domain and hit publish. To date we’ve had 56,000+ downloads of the templates on our marketplace! Here’s why you should consider Google Sites: Responsive fast-loading themes Google’s easy site builder Run your website free forever Shop Now

➜ Sheets Tip #350: How to use the RANK function to determine ranking position

Suppose 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:

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:

If you enjoyed this newsletter, please forward it to a friend who might enjoy it.

Have a great week!

Cheers,
Ben

P.S. Hypothesis testing with Dad​