+ Reply to Thread
Results 1 to 3 of 3

Find Number Closest to Zero

  1. 12-04-2009, 05:21 PM #1
    snapa
    snapa is offline
    Registered User
    Join Date
    03-26-2007
    Location
    USA
    MS-Off Ver
    2000
    Posts
    32

    Find Number Closest to Zero

    I need to find which number in a row would be closest to zero, then display the associated name. The number can be negative.

    I used this, which works well if all the numbers are positive:

    =INDEX($C$1:$E$1,MATCH(MIN(C66:E66),C66:E66,0))

    I'm running into a problem when the closest number is negative. Any help would be greatly appreciated.
    Last edited by snapa; 12-04-2009 at 05:35 PM.
    Reply With QuoteRegister To Reply
  2. 12-04-2009, 05:29 PM #2
    tigertiger
    tigertiger is offline
    Valued Forum Contributor
    Join Date
    11-11-2008
    Location
    Euro
    MS-Off Ver
    2007, 2010
    Posts
    470

    Re: Find Number Closest to Zero

    Try array formula:
    =INDEX($C$1:$E$1,MATCH(MIN(ABS(C6:E6)),ABS(C6:E6),0))

    after type the formular, plz, Press Ctrl+Shift+Enter
    Reply With QuoteRegister To Reply
  3. 12-04-2009, 05:34 PM #3
    snapa
    snapa is offline
    Registered User
    Join Date
    03-26-2007
    Location
    USA
    MS-Off Ver
    2000
    Posts
    32

    Re: Find Number Closest to Zero

    Worked like a charm. Much thanks tigertiger!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1