| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I find the 10 lowest numbers in a list?
You're welcome.........and another thing you might try is Data Filter
Autofilter Top 10 and select Bottom 10............. Vaya con Dios, Chuck, CABGx3 "Carl" wrote: 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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| find sum in list of of numbers | Excel Discussion (Misc queries) | |||
| find sum in list of of numbers | Excel Discussion (Misc queries) | |||
| find sum in list of of numbers | Excel Discussion (Misc queries) | |||
| find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
Threaded Mode
