This does not work:-
=DMIN(Road_Bike, Road_Bike,2)
I assume I am completetly wrong.
I have a named range “Road_Bike” (N2:N100) that contains positions of competitors. These positions are numbers but not in order e.g.
10
17
6
21
4
13
etc
I can use MIN to get the lowest score, 4, however I want the second lowest, 6.
How can I get this result?
Any adice please?