Thread
:
Formula
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
joeu2004[_2_]
external usenet poster
Posts: 829
Formula
"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")
Reply With Quote
joeu2004[_2_]
View Public Profile
Find all posts by joeu2004[_2_]