Results 1 to 10 of 10

Why dictionary very slow ,is dictionary have maksimum data

Threaded View

  1. #1
    Forum Expert
    Join Date
    11-28-2015
    Location
    indo
    MS-Off Ver
    2016 64 bitt
    Posts
    1,513

    Why dictionary very slow ,is dictionary have maksimum data

    I am using excel 2016 64 bitt
    I have data in col a:j
    My key is a&b&c...&j
    But it very slow,is so multi Compleks criteria
    My data 80.000 row
    sub test()
    Dim txt$,i&,x
    With [A1].CurrentRegion
      x = .Value
      With createObject("Scripting.dictionary")
       For i = 1 to Ubound(x)
        With application
         txt = Join(.transpose(.transpose(.index(x,i)),",")
       .item(txt) = .index(x,i)
       End with
     Next i
    End with
    End with
    End sub
    But if using array is very fast
    But my data not similar arrange data
    Must to sort but so complek data imposibble to sort
    sub arr()
    Dim ar(),i&,n&, x,j&,k&
    x =[a1].CurrentRegion.value
      Redim ar(1 to ubound(x),1 to ubound(x,2))
      For i = 2 to ubound(x)
         n = i-1
         For j = 1 to ubound(x,2)
            If x(i,j) = x(n,j) then
              k = k + 1
              ar(1,j) = x(n,j)
              ar(k,j) = x(i,j)
            End if
         Next j
      Next i
    End sub
    Last edited by daboho; 10-30-2018 at 04:14 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adding dictionary into dictionary and retrieving data
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-08-2018, 06:52 AM
  2. [SOLVED] Dictionary or Scripting.Dictionary. Binding Referencing Dim-ing. Sub routines and Function
    By Doc.AElstein in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 07-12-2016, 08:28 AM
  3. [SOLVED] How to compare keys in one dictionary to keys in another dictionary
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-15-2015, 02:27 PM
  4. Storing a Dictionary into a Dictionary Object
    By pago_boss in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2015, 03:04 AM
  5. Dictionary - Using a dictionary of dictionaries to hold individual orders
    By wazimu13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-09-2015, 08:32 PM
  6. [SOLVED] Code using dictionary class is too slow- need it work faster if possible.
    By strud in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 02-04-2014, 12:09 PM
  7. [SOLVED] Linking MS dictionary as data into Excel
    By Yabbadoo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2005, 07:06 PM

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