Formula
PS.... I wrote:
"Garry Oder" wrote:
Can anyone assit with a formula for detirmining if a
number in a group of 20 is one of the lowest 8.
=IF(F1<=SMALL(F$1:F$20,8),"yes","no")
It just occurred to me that you wrote "if a number ... __is__ one of the
lowest 8", not if it fits among the lowest 8.
Try the following normal formula (just press Enter despite the array
constant):
=IF(OR(F1=SMALL(F$1:F$20,{1,2,3,4,5,6,7,8})),"yes" ,"no")
|