| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I find the 10 lowest numbers in a list?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I find the 10 lowest numbers in a list?
Hello Carl,
If you have a large amount of data to check, I would suggest investing some time to create a pivot table. Once you have a pivot table created and listing the data you want to find the bottom 10 of, right click the table, then 'field settings' then 'advanced' and select the options to list just the bottom 10. HTH "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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
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. |
| Reply |
| 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 | |||
Linear Mode
