Ranking by two columns of data

[kolokoy]

I am having trouble ranking my data in Excel based on 2 columns. The 2 columns are CYCLE and DURATION. The ranking should work like this:

1. It should rank CYCLE first then DURATION second.
2. The formula should work even if the data is not sorted or with blanks.

For instance, here is my sample data and the EXPECTED ranking:

[TABLE="width: 197"]
<tbody>[TR]
[TD]DURATION[/TD]
[TD] CYCLE[/TD]
[TD]RANK[/TD]
[/TR]
[TR]
[TD]0:44:59[/TD]
[TD]1[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]1:24:02[/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]0:56:59[/TD]
[TD]1[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]2:00:09[/TD]
[TD]2[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]0:45:06[/TD]
[TD]1[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]1:46:07[/TD]
[TD]2[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]2:25:12[/TD]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1:32:56[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]

This is exactly the same scenario with this post or thread:
http://www.mrexcel.com/forum/excel-questions/293980-ranking-two-columns-data.html

However, the only DIFFERENCE is that my data has blanks! I have tried the formula that worked in the thread above and it produced wrong results due to blank rows.

I cannot attach my file, I don't see a way to attach it. Here is the link, I uploaded it in a file sharing site:
Download rank-the-speed.xlsx - FilesXpress

Thank you.