How can I find the 10 lowest numbers in a list?
Thanks, Chuck. This worked great!
"CLR" wrote:
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.
|