+ Reply to Thread
Results 1 to 6 of 6

How to speed up this index match function

  1. 07-26-2015, 11:20 PM #1
    fluffyvampirekitten is offline
    Registered User
    Join Date
    07-01-2015
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    66

    How to speed up this index match function

    I have these lines of codes and this macro runs really slow until it stop responding at some point of time
    Any suggestion to speed up this macro ?
    Both files are dynamic.


    Any idea?[/COLOR]
    Please Login or Register  to view this content.
    Really need it urgently

    Cross Ref: http://www.mrexcel.com/forum/excel-q...ml#post4226694



    Just updated my code cos the copy/paste and autofill wasnt working properly.
    However it is still running slow 

    Please Login or Register  to view this content.
    Last edited by fluffyvampirekitten; 07-27-2015 at 03:05 AM.
    Reply With QuoteRegister To Reply
  2. 07-26-2015, 11:56 PM #2
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: How to speed up this index match function

    Try this... 

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    Reply With QuoteRegister To Reply
  3. 07-27-2015, 12:00 AM #3
    prabhuduraraj09 is offline
    Forum Contributor prabhuduraraj09's Avatar
    Join Date
    05-19-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    330

    Re: How to speed up this index match function

    Hi,

    You have to turn off some Excel functionality so your code runs faster

    Please Login or Register  to view this content.
    Thank you

    If I have helped you in someway, use the * icon below to give reputation feedback, it is appreciated.
    Reply With QuoteRegister To Reply
  4. 07-27-2015, 01:28 AM #4
    Jacc is offline
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,883

    Re: How to speed up this index match function

    The first thing to learn when writing macros is that the Select command should be avoided because it slows it down a lot.

    This is slow code
    Please Login or Register  to view this content.


    This is much faster 
    Please Login or Register  to view this content.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
    Reply With QuoteRegister To Reply
  5. 07-27-2015, 01:56 AM #5
    fluffyvampirekitten is offline
    Registered User
    Join Date
    07-01-2015
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    66

    Re: How to speed up this index match function

    Quote Originally Posted by :) Sixthsense :) View Post
    Try this... 

    Please Login or Register  to view this content.

    It load quite fast but....
    Oh my god. it seems that it didnt fill up all the rows
    And copy/paste isnt working , any help.
    Reply With QuoteRegister To Reply
  6. 07-27-2015, 03:50 AM #6
    fluffyvampirekitten is offline
    Registered User
    Join Date
    07-01-2015
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    66

    Re: How to speed up this index match function

    Finally it can load faster than before ,
    I also add a few codes to open up the another reference , it seems that it also did a trick .
    THANK YOU SO MUCH! Really appreciated <3
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Problems applying INDEX-MATCH-MATCH function on other data
    By LennartB in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-13-2015, 05:33 AM
  2. INDEX(MATCH)) / LOOKUPS Processing Calculator Speed
    By AstToTheRegionalMGR in forum Excel General
    Replies: 1
    Last Post: 02-17-2015, 10:57 AM
  3. [SOLVED] Stuck on Match function with #N/A; attempting to reverse Index/Match
    By Cappytano in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-10-2014, 06:39 PM
  4. Lookup or Index(match) function not in ascending order and not an exact match
    By Tobias1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-17-2013, 12:37 PM
  5. [SOLVED] Help speed up slow INDEX (SMALL function
    By submariner18 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-12-2012, 01:14 PM
  6. Improving Speed of Index and Match Functions
    By hazza147 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-30-2010, 01:05 PM
  7. Match/Index Calcuation Speed
    By Rochy81 in forum Excel General
    Replies: 1
    Last Post: 10-01-2008, 04:19 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1