Forum

Hi Jacek, Yes, just double click the name on the left hand side of the PQ editor and type in the new name. Or, click the query name on the left ...

Hi Kalin, Is it worth learning? Depends on whether or not you will use it. If you are doing work that requires reporting and analysis then yes you...

Hi Martin, I understand the purpose of the ##TEMP table in SQL Server but are you sure it is necessary to create one in PQ? I obviously don't kn...

Hi Hannu, You'll have to be more specific as I don't understand enough about the problem. Please include a link to the site you are trying to ac...

Hi Robb, I used helper columns because I felt it was easier to split the text string (1,2,3) up in the sheet and then feed that into the array form...

Hi Helen, Nothing in the code jumps out at me but I don't know what values the various ListCounts take. If they are very large for some reason that...

Hi Armando, I'd just use SUBSTITUTE str = WorksheetFunction.Substitute(Range("A1"), ". ", ". 0") where your title is in A1. Regards Phi...

Hi Robb, I journeyed down a few rabbit holes working on this as there are several ways it could be solved. In the end I decided to use some helper...

Hi Steven, Shockwave Flash is old technology and shouldn't be used. Surprised it's still an option you can choose. Regards Phil

Hi Jason, Can you post the file(s) containing the queries, and any necessary source data, so we can have a look. Thanks Phil

Hi Bruno, This is getting very messy and complicated. I've looked at the 3 files you've most recently supplied and unfortunately that just confuse...

Cross posted to here Do not cross post without linking to the cross post to let us know

No worries Pieter 🙂

Hi Pieter, Please see attached file for solution. The result is on Sheet1. Regards Phil

OK, glad to hear it's working now.