Thread: SMALL function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default SMALL function

Looking at the way your formula is constructed it appears that you want the
min that is greater than 0 so I guess that means then are no negative
numbers.

Try this array formula** :

=MIN(IF((MOD(COLUMN(E51:AL51),3)=2)*(E51:AL510),E 51:AL51))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Wally3178" wrote in message
...
Hi,

I am trying to display the minimum temperature for the year by using the
following formula:

=SMALL(E51,H51,K51,N51,Q51,T51,W51,Z51,AC51,AF51,A I51,AL51,COUNTIF($E51,$H$51,$K$51,$N$51,$Q$51,$T$5 1,$W$51,$Z$51,$AC$51,$AF$51,$AI$51,$AL$51,0)+1)

Can anyone tell me why this formula won't work?

The cells are each months minimum temperature which is calculated using
the
MIN function

Cheers,
--
Wal