Results 1 to 9 of 9

Picking the second value out of two results

Threaded View

Hitch75 Picking the second value out... 09-22-2010, 05:25 AM
BlastRanger Re: Picking the second value... 09-22-2010, 05:43 AM
Hitch75 Re: Picking the second value... 09-22-2010, 05:45 AM
BlastRanger Re: Picking the second value... 09-22-2010, 06:01 AM
Hitch75 Re: Picking the second value... 09-22-2010, 06:54 AM
BlastRanger Re: Picking the second value... 09-22-2010, 06:58 AM
Hitch75 Re: Picking the second value... 09-22-2010, 11:10 AM
BlastRanger Re: Picking the second value... 09-23-2010, 02:34 AM
Hitch75 Re: Picking the second value... 09-23-2010, 06:13 AM
  1. #1
    Forum Contributor
    Join Date
    03-16-2007
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2007
    Posts
    202

    Picking the second value out of two results

    Hi guys

    Can someone help me solve this?

    In the example attached, the red formula calculates which of the numbers in columns A-G has the closest value to the number given in the blue column.

    Out of 6, 14 and 18, the closest one to the given number (12) is 14.

    However, when two of the numbers are at the SAME distance to the given number, as in the last two rows, formula returns the first one of them, and i would like it to return the SECOND one.

    So, i want the results of the last two rows to be 10 and 13.

    Any ideas how to fix this?

    Thanks!
    Attached Files Attached Files

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