In B2, =SMALL($B$2:$B$8, SUM(COUNTIF($B$2:$B$8, F$1:F1)) + 1)

... confirmed with Ctrl+Shift+Enter