Results 1 to 6 of 6

Match prices within a range

Threaded View

  1. #1
    Registered User
    Join Date
    06-09-2010
    Location
    Copenhagen, Denmark
    MS-Off Ver
    Excel 2003
    Posts
    5

    Match prices within a range

    Hi, I need a function which enables me to check if two sets of data is identical. Look at my attached example.

    funcA should match the price in column C with the price in column H if the number from column A are identical with the number from column F.
    It should evaluate the price within a range of +/-1.00 (fx: the function will positively match the prices in row 2, because the difference between 224,067.87 and 224,067.47 are less than +/-1.00).
    If the function are able to find a positive match, it should return "OK"
    If the function are not able to find a positive match, it should return "DIFF"

    Likewise, funcB should match the price in column H with the price in column C if the number from column F are identical with the number from column A.
    It should consider the same criteria as funcA.

    I sincerely appreciate your time. I know this is a challenging task!

    In advance, thank you!

    BR
    Tobias
    Attached Files Attached Files

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