Hi

Welcome to the board

This is one solution. please try:

A B C D 1value row row k-th smallest 21 1 1 32 2 3 41 3 9 53 4 2 64 5 6 72 6 4 84 7 5 95 8 7 101 9 8 11[Book1]Sheet1

Addr Formula [Book1]Sheet1 C2 =SMALL(IF($A$2:$A$10=SMALL($A$2:$A$10,ROWS($C$2:C2)),$B$2:$B$10),ROWS($C$2:C2)-COUNTIF($A$2:$A$10,"<"&SMALL($A$2:$A$10,ROWS($C$2:C2)))) This in an array formula and so MUST be confirmed with CTRL+SHIFT+ENTER and not just ENTER. Copy down

## Like this thread? Share it with others