Low numbers and dates question

[supermario77]

Hi
I have a row of numbers
k4:k59 that also contain blanks and zeros
and duplicate numbers
I want to rank the numbers by
1st
2nd
3rd
4th and 5th
But I do not want duplicate results, eg 2nd and 3rd to be the same result.
every position (1st, 2nd 3rd etc should be unique)
No blanks or zeros
I would like the results displayed in k60:k64

There is also a date in a4:a59. I would like the date corresponding to
the low numbers dispalyed in l60:l64

Any help is appreciated
thanks
supermario

[olasa]

Here is one solution (see enclosed zip-file). Just move the formulas to the right Positions.

Hope it helps

Ola Sandström