Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Return minimum POSITVE value from range
Hi, Suppose I have a worksheet with the following data: (column1)......... (column2) Savings..................I.D. -243...................... 01 -205...................... 02 -165.......................03 -87.........................04 57..........................05 109........................06 205........................07 303........................08 What I need to do is look up the smallest -positive- number in the "Savings" column and the look over to the "I.D." column and retrieve the corresponding I.D. So in the above example, look up the value 57 and then retrieve the corresponding I.D. of 05. Is there a way to do this? I would have thought an array formula of some kind but I haven't met with any success so far. In my actual spreadsheet I have over 10,000 entries in the "Savings" column so any formula would need to be efficient. Thanks in advance -Rob -- TheRobsterUK ------------------------------------------------------------------------ TheRobsterUK's Profile: http://www.excelforum.com/member.php...fo&userid=9924 View this thread: http://www.excelforum.com/showthread...hreadid=470975 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create range bar graph | Charts and Charting in Excel | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
Dynamic Print Range Help | Excel Worksheet Functions |