Results 1 to 4 of 4

Closest match multiple variables

Threaded View

zack7373 Closest match multiple... 03-08-2013, 06:42 PM
Jacc Re: Closest match multiple... 03-09-2013, 07:52 AM
zack7373 Re: Closest match multiple... 03-11-2013, 10:37 AM
Jacc Re: Closest match multiple... 03-11-2013, 11:30 AM
  1. #1
    Registered User
    Join Date
    02-22-2013
    Location
    AZ
    MS-Off Ver
    Excel 2010
    Posts
    2

    Closest match multiple variables

    Here is a sample of the data set I have:

    DIRMKT TIME YEAR --- DIRMKT TIME YEAR
    ALBDCA 0535 2012 --- AGSDCA 1940 2013
    BDADCA 1255 2012 --- ALBDCA 1153 2013
    BDLDCA 0620 2012 --- ALBDCA 1710 2013
    BDLDCA 0938 2012 --- BDADCA 1350 2013
    BDLDCA 1150 2012 --- BDLDCA 0620 2013
    BDLDCA 1338 2012 --- BDLDCA 0938 2013
    BDLDCA 1635 2012 --- BDLDCA 1152 2013
    BDLDCA 1939 2012 --- BDLDCA 1330 2013
    BHMDCA 1755 2012 --- BGRDCA 1727 2013

    I am trying to find a way to find the closest match of the time column in the right set of data to the corresponding time column in the first set, but only when the dirmkt is the same. For example, second from the bottom on the right set BDLDCA 1330 would return 1338 since that was the closest value in the left set of data with the SAME dirmkt. Any help would be amazing....I'm stuck. Thanks!!
    Last edited by zack7373; 03-11-2013 at 07:05 PM.

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