+ Reply to Thread
Results 1 to 3 of 3

speed up a PowerQuery - find and replace formula

  1. 11-21-2023, 01:49 PM #1
    afgi
    afgi is offline
    Forum Contributor
    Join Date
    09-13-2010
    Location
    Poland
    MS-Off Ver
    365
    Posts
    204

    speed up a PowerQuery - find and replace formula

    hi,
    is there any way to speed up the the query in the file attached? I am trying to find and replace multiple items in multiple columns using a separate list.

    the file attached works smoothly, but only because it is few time smaller. With 1 800 rows, it takes over an hour to run the query.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-28-2023, 01:15 AM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2406 Win 11 Home 64 Bit
    Posts
    24,029

    Re: speed up a PowerQuery - find and replace formula

    Getting error message that tables are missing. Cannot offer further help as data is absent from your file.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 11-28-2023, 09:29 AM #3
    afgi
    afgi is offline
    Forum Contributor
    Join Date
    09-13-2010
    Location
    Poland
    MS-Off Ver
    365
    Posts
    204

    Re: speed up a PowerQuery - find and replace formula

    hi,

    sorry, now should be fine
    Attached Files Attached Files
    Last edited by AliGW; 11-28-2023 at 09:35 AM. Reason: Please do NOT quote unnecessarily! Use the QUICK REPLY button instead.
    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. How to speed up VBA/Use powerquery instead?
    By sblair9691 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2021, 09:33 AM
  2. Find and Replace dialogue keeps closing when clicking Find Next / Replace / Replace All
    By guyglk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-13-2021, 03:32 AM
  3. Need VBA Help to speed up/replace formula
    By jdegeorge in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-18-2017, 04:08 PM
  4. [SOLVED] Speed up; replace Formula parts
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-17-2017, 12:24 PM
  5. [SOLVED] Find and replace where contents a formula so can't be seen by Find and replace.
    By markDuffy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2015, 02:24 PM
  6. How can I speed up this find & replace VBA
    By Jennasis in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-13-2013, 09:56 AM
  7. [SOLVED] how to speed Find/Replace in Excel(Using VB)
    By replace one tag in content of one cell a in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2006, 05:20 AM

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