Formula
Hi Garry,
Am Tue, 6 Mar 2012 10:12:45 +0000 schrieb Garry Oder:
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.
try:
=IF(RANK(F1,$F$1:$F$20,1)<=8,F1,0)
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|