View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default How can I find the 10 lowest numbers in a list?

With your list in column A, put this in B1 and copy down.........

=IF(A1<SMALL(A:A,11),A1,"")

Vaya con Dios,
Chuck, CABGx3



"Carl" wrote:

Is there a way to find the 10 lowest numbers in a list? No problem finding
one minimum, but need 10 lowest. Thanks in advance.