| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display 3 lowest numbers in column.
I have reviewed Microsoft's help and cannot find anything to answer my
question. I have a column with labels, and 5 columns with numbers (prices). I need the 3 lowest prices from each column displayed elsewhere, along with the accompanying labels. Can anyone point me in the right direction? I don't know whether this would involve formulas, filtering, or some other function I don't know about yet. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display 3 lowest numbers in column.
Take a look at the Small function. That should get you started. You can then
use index and match or vlookup to return the corresponding labels. Wtihout more info I can not comment further... -- HTH... Jim Thomlinson "Brinker1975" wrote: I have reviewed Microsoft's help and cannot find anything to answer my question. I have a column with labels, and 5 columns with numbers (prices). I need the 3 lowest prices from each column displayed elsewhere, along with the accompanying labels. Can anyone point me in the right direction? I don't know whether this would involve formulas, filtering, or some other function I don't know about yet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to add 4 lowest numbers from a column of 6 | Excel Worksheet Functions | |||
| Find the 10 lowest of 20 numbers in column and enter those 10 in a | Excel Worksheet Functions | |||
| Search lowest value in a column and display the entire row | New Users to Excel | |||
| How do you add the three lowest numbers in a column? | Excel Worksheet Functions | |||
| How do I display the lowest value in a row? | New Users to Excel | |||
Hybrid Mode
