Results 1 to 14 of 14

how to find address of a range of cells that contain a value closest to a given value?

Threaded View

  1. #1
    Registered User
    Join Date
    10-20-2010
    Location
    Chicago, Illinois
    MS-Off Ver
    Excel 2007
    Posts
    69

    how to find address of a range of cells that contain a value closest to a given value?

    Hi,
    I am using Excel 2007 and I'm trying to write a formula that will locate and provide me with the address of the cells that contain values closest to my given value.

    for example if my given value is 1604...and in column A I have the following values...

    A1 1585
    A2 1590
    A3 1595
    A4 1600
    A5 1605
    A6 1610
    A7 1615
    A8 1620
    A9 1625

    i would like a formula that returns A4:A5


    "Close in value" means the two closest cells that contain a value closest to my given value. First cell that is => my given value and first cell that is =< my given value

    also I should mention i would like this to be something that is done dynamically... the values in my spreadsheet are updating in real-time

    thanks
    Last edited by xelhelp; 03-26-2012 at 12:55 PM. Reason: more info

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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