+ Reply to Thread
Results 1 to 2 of 2

Return a list of unique matches (data source file different from formula file)

  1. #1
    Registered User
    Join Date
    01-23-2007
    Posts
    2

    Return a list of unique matches (data source file different from formula file)

    http://www.excelforum.com/showthread.php?t=581581

    Hi,

    I need something like the file attached in (in Carim's reply) the above link. The formula does not seem to work if the data source is in a different file and the data source file is closed. Can anyone please help me with this? Thank you.

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    If you are working with closed files,
    have look at the following to understand the challenge ...

    http://www.dailydoseofexcel.com/arch...sed-workbooks/

    Harlan Grove's pull function does work but it is extremely slow ...
    most efficient solution is Laurent Longre add-in ..
    HTH
    Carim


    Top Excel Links

+ 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