How can I find the 10 lowest numbers in a list?
Another way would be to do Data Filter Autofilter, and select the "TOP
10" selection and convert it to "Bottom 10" in the window......to get back
out to normal, just do Data Filter Autofilter again....it's a toggle
Vaya con Dios,
Chuck, CABGx3
"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.
|