Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hey,
How can search a range of numbers (ex. E15:I15) and have it find the 2 lowest numbers in the range (most likely 0 and 0) and give me the header number at the top of the column. And if there's more than 2, give me all of the lowest possible numbers. Ex. Headers - 1 2 3 4 8 1 0 1 2 0 Then I would want the formula to give me the header of that row which the two 0's are in (so it would give me "2,8". Thanks! Matt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
lookup range of numbers; return corresponding data for the fixed r | Excel Worksheet Functions | |||
I need to return the lowest time value in a range of cells. | Excel Worksheet Functions | |||
How to return a single value for a range of numbers | Excel Worksheet Functions | |||
Range vs. lowest #, 2nd lowest #, 3rd lowest #, etc | Excel Discussion (Misc queries) | |||
How can I get the lowest price, second lowest etc. from a range o. | Excel Worksheet Functions |