Rank function, based on 2 criteria / columns

Hallo,

I am not sure if this is the right forum, but I'll give it a go.

Is it possible to calculate a rank, based on 2 columns / criteria.
I need to calculate the position of speedskaters based on time and distance.

Example:

Please Login or Register  to view this content.

Please be aware that both the number of distances and time can vary!
Other distance are e.g. 1500, 5000 etc.

Also: distances and times are not always in alphabetical order

Is this possible (directly with the rank formula or with VBA

I have searched for the answer, and came across the SUMPRODUCT formula (which apparently is used a lot).
I don't think this is the answer.

Who knows what to do?

Thanks in advance

if your DISTANCE values are in A2:A10, TIME in B2:B10, then place this in C2 and drag-fill down:

Please Login or Register  to view this content.

what do you want to happen if there are duplicate TIME values for a certain DISTANCE value?