Well there's 80 pieces of data which is why I didn't initially post. However, I do know for certain that there are repeated values. I also checked it in an online calculator for Spearman's Rank (which is what I'm trying to work out), which provides the same results as mine for the first set of data, and provides averages of ranks for repeated values in the second set. For some reason, this isn't the case in excel.
If the numbers are same, e.g. 3.7 and 3.7, excel will simply rank them as 1 and 2, instead of 1.5
Bookmarks