Last seen: Jul 3, 2025
can you explain how you intended to rejoin the data? I saw only one index column and I couldn't figure it out (which is why I re-tried the original so...
Hi, SQL query text is just a text string, use concatenation symbol & just like in any excel string or VBA, you can take data from a table with ...
Columns are removed from a pivot table ONLY if you overwrite the headers as well when you paste the real data into source table.. Why are you repla...
I used the fields you have indicated originally: Is there any easy way to subtract one line from the previous line given the name and company mat...
Query1 and Entry2 are 2 different PQ solutions, the processing time is almost the same, but I doubt that it can be made faster than it is. Entry an...
Getting data from sharepoint folder is not the same thing as getting data from local file or folder, you have to adjust the query. Microsoft 365 ha...
PP is much faster, that's why I mentioned it. See attached PP version, takes a few seconds for 20 k test data. I split the data into Entry and E...
Hi Adam, The last query provided took 2 min and 20 seconds on my PC to process those 20k records, generated a little over 10k rows. If we extrapola...
RefreshAll works different in VBA than from user interface, in VBA will not raise error message when a query fails. Loop through connections and re...
Hi, You're using wb.RefreshAll or you refresh each query one by one? Can you post the code you're using to refresh?
Because you mentioned power BI, you could write a measure to calculate the Exit dates... Split the initial data into 2 tables (one for Entry, one f...
Hi Adam, The FilterTable function is executed at each row, filtering the source data to get the exit time for each record is not efficient. It c...
You're welcome 🙂
Hi Alan, I see that you have formatted column A as fraction, but this format can handle inches, not feet. In this case, you can type column A value...
Hi Honzik, That's a hard nut to crack, checking if the product is in previous period to reset the counter is mind blowing, have no idea why that re...