Thread: Small
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Small

=SMALL(A2:O2,1)

Vaya con Dios,
Chuck, CABGx3



"tom" wrote:

I have a range of numbers that (A1:O2) that I would like to return the
smallest number in that range. How do I right the formula?
A1:O1 - header row
A2:O2 - Data set.

TFTH,
Tom