Results 1 to 8 of 8

Slow index/small/row array

Threaded View

  1. #1
    Registered User
    Join Date
    08-17-2012
    Location
    Serbia
    MS-Off Ver
    Excel 2010
    Posts
    85

    Slow index/small/row array

    I am trying to select companies from list of 7000 companies by two criteria.
    1. 7000 companies with corresponding values
    2. Based on that values (I have a combo box) companies are selected from that list of 7000
    3. Using combination of index/small/row functions, that selection is sorted in another column to ignore blank cells
    4. Whole process is repeated one more time using second criteria.

    If someone could check uploaded workbook for another method for index/small/row array to speed up the whole process.
    I know it's not that slow right now, but with fetching web data and with other calculations that comes after that process
    opening time is pretty slow.

    LIST_SPEED TEST.xlsm
    Last edited by Jovica; 12-05-2012 at 04:37 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