Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identifing smallest numbers
I have 3 columns of non-consecutive data in several rows.
Column 1 has description A, description B, description C, description A, description M, etc. Column 2 has description AA, description AD, description AF, description AD, description AO, etc Column 3 has amounts. I need a formula that searches column 1 for all instances of description A. Based on the smallest value associated with the description A items, I want to place the description of column 2 (description result would be in the same row as the smallest value) into the cell the formula is written in. In the cell next to the formula above, I want to place the value (i.e. the smallest value) that corresponds to the first formula's answer/result. Both formulas will need to extract the 2nd smallest number, the 3rd smallest number, the 4th smallest number, etc. (It appears the SMALL function defined within Excel would be the perfect use of this formula). |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Identifing smallest numbers
Why not simply sort by column 1 and then column 3 which will give you the
sequence you require? "M Moore" wrote: I have 3 columns of non-consecutive data in several rows. Column 1 has description A, description B, description C, description A, description M, etc. Column 2 has description AA, description AD, description AF, description AD, description AO, etc Column 3 has amounts. I need a formula that searches column 1 for all instances of description A. Based on the smallest value associated with the description A items, I want to place the description of column 2 (description result would be in the same row as the smallest value) into the cell the formula is written in. In the cell next to the formula above, I want to place the value (i.e. the smallest value) that corresponds to the first formula's answer/result. Both formulas will need to extract the 2nd smallest number, the 3rd smallest number, the 4th smallest number, etc. (It appears the SMALL function defined within Excel would be the perfect use of this formula). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting | Excel Worksheet Functions | |||
How to generate sets of random numbers without having duplicates | Excel Worksheet Functions | |||
Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
How do I sort letters before numbers in Excel? | Excel Discussion (Misc queries) | |||
Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) |