Can anyone assit with a formula for detirmining if a number in a group of 20 is one of the lowest 8. I have been trying "=IF(F1<MEDIAN(F$1:F$20),F1,0)" This seems to give me one of the lowest 10 out of the group of 20.
Any suggestions would be greatly appreciated.

Thanking you in anticipation

Garry