+ Reply to Thread
Results 1 to 2 of 2

Search up/down from n'th term and retrieve value if minimum difference

  1. #1
    Registered User
    Join Date
    05-26-2010
    Location
    Calgary
    MS-Off Ver
    Excel 2003
    Posts
    7

    Search up/down from n'th term and retrieve value if minimum difference

    Hi, new here, sorry if my question is not very clear.

    I have two columns of data for example:

    A
    1.25
    1.3
    1.305
    1.307

    B
    1.15
    1.3
    1.45
    1.6

    Column B's numbers are considered the 'n th' term
    I need to filter through column A with term 'n' and find the nearest values in A that are above and below n by at least difference of 0.1 but no greater than 0.2

    If the difference is less than 0.1 between 'n' and the above/below number is A, then somehow I need to search again but this time 2 terms away from n.

    I think there are some functions in VBA which would make my job easier, as I have only done c++ before.

    Thanks, I appreciate the help,

    Michael

  2. #2
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Search up/down from n'th term and retrieve value if minimum difference

    I suggest you post a workbook which includes an illustration of your desired results.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1