Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Another day another wrinkle- Choose last instance of phrase and delete rest of rows
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular
    Join Date
    Mar 2010
    Location
    New England
    Posts
    419
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Another day another wrinkle- Choose last instance of phrase and delete rest of rows

    Thanks,

    I think I figured it out.

    DThib

  2. #12
    Board Regular
    Join Date
    Mar 2013
    Posts
    805
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Another day another wrinkle- Choose last instance of phrase and delete rest of rows

    Out of curiosity, any time improvement ?

  3. #13
    Board Regular
    Join Date
    Mar 2010
    Location
    New England
    Posts
    419
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Another day another wrinkle- Choose last instance of phrase and delete rest of rows

    Yes.
    It now takes 1 minute and 55 seconds for the large download. About 1 minute 30 seconds for the individual tabs.
    Thanks for your help!

    You are Sparky!!!

  4. #14
    Board Regular
    Join Date
    Mar 2013
    Posts
    805
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Another day another wrinkle- Choose last instance of phrase and delete rest of rows

    Hmmm... that's still about 8 minutes with things moved from the IQP sheet into memory to be worked with.
    I'd have expected a much greater improvement than that.
    Have a suspicion I don't handle the in memory arrays properly or efficiently.
    Anyway if you're happy, I'm happy.
    Thanks for letting me know.

  5. #15
    Board Regular
    Join Date
    Mar 2010
    Location
    New England
    Posts
    419
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Another day another wrinkle- Choose last instance of phrase and delete rest of rows

    It is still Waaaaaaay better than before 8 minutes per Tab and 18 minutes for a complete download.

    Thanks for the tweak on the code.

    DThib

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •