Results 1 to 8 of 8

Return minimum POSITVE value from range

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-26-2004
    Location
    Halifax, UK
    MS-Off Ver
    Office 365 v2402
    Posts
    263

    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
    Last edited by TheRobsterUK; 09-26-2005 at 08:24 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1