00:00Have you got into a situation where your rank number is exactly the same because your score is
00:04exactly the same like in the Netherlands and New Zealand? Let me demonstrate. You're going to say
00:09equal rank open parenthesis c3 is your number that you want to rank comma and then the second
00:16argument is your reference which we're going to highlight the whole column here like this.
00:21Going to press f4 to make both the row and the column fix close parenthesis and hit enter and
00:27I'm going to apply the same formula to the rest of the row like this. As you can see the
00:31rank number
00:32for Netherlands and New Zealand is exactly the same. They are ranked as 5. Why? Because your score is
00:38exactly the same. How do you get around it? Well you're going to have to add a countif function here
00:44but before we add the countif function to our rank let me show you what the countif function
00:48does. You're going to say equal countif open parenthesis and the first one will be the range
00:55itself and we're going to make this the second part of the range fixed by pressing f4 here like this
01:01and then the second argument for the countif is essentially your criteria which is going to be
01:06your value in c3 close parenthesis and we're going to what we're going to do is we're going to minus
01:12one here and hit enter
01:14you
Comments