Scribd
Upload
24 views2 pages

Name Round 1 Round 2 Round 3 Round 4 Total Position: Function

The document shows team scores over 4 rounds of competition with a total score. Team 1 scored the highest total of 16 points and was in 1st position, while Team 5 scored the lowest total of 10 points and was in 4th position.

Uploaded by

Lesley Keddy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
24 views2 pages

Name Round 1 Round 2 Round 3 Round 4 Total Position: Function

The document shows team scores over 4 rounds of competition with a total score. Team 1 scored the highest total of 16 points and was in 1st position, while Team 5 scored the lowest total of 10 points and was in 4th position.

Uploaded by

Lesley Keddy
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Name Round 1 Round 2 Round 3 Round 4 Total Position

Team 1 4 5 3 4 16 1
Team 2 3 3 3 6 15 2
Team 3 =RANK(F2,$F$2:$F$5)
Team 4 4 5 3 2 14 3 You have to absolute the range
Team 5 3 4 2 1 10 4
F2 = first number
Total 14 17 11 13 55 F2:F5 = the range you want to know t
to F4 this (not sure if F4 works on a m
put $ signs around

This link explains it well:

[Link]
function
$F$2:$F$5)

o absolute the range

umber
e range you want to know the ranks of - you have
not sure if F4 works on a mac but you have to
around

plains it well:

[Link]/excel-functions/excel-rank-

You might also like