Last seen: Jul 8, 2026
The syntax for INDEX and MATCH was incorrect. INDEX takes an array and then a row and a column reference. The row and column numbers are, in turn, det...
Please try to upload the picture (or better a file) again. Don't forget to press "Start upload" before you submit your reply.
I don't believe you can trigger a query refresh based on changes in the folder it connects to. Though you can control the refresh rate in Query Proper...
Perhaps the attached file contains a solution that might work for you.
The file did not attach. Try agan and don't forget to press "Start upload" before submitting your reply. By the way, what YT post are you referring...
See if you can work with the attached file. I created a new query to the Bonds URL from your initial post. I'm working on a PC that has the UK number ...
Your file didn't come through, but assuming the three columns are numbers like 5, 2 and 2023 then you can add a custom column with the following funct...
Hi Chelle, I overlooked your first question regarding how to reorganise the data and took your last sentence as a confirmation that all was clear. ...
Couldn't resist to add another solution that doesn't require complicated formulas or rearranging of the data in an Excel sheet. I used Power Query ...
Can you provide a file? Otherwise we'll be guessing as to what type of data you are working with.
@Hans Hallebeek. You can right-click on the file (e.g. in post # 5) select "Save link as". It than allows you to save the file to a folder on your com...
I suspect that this related to your other question. Link below.
Hi, In PQ, first unpivot your data table. Select the Partner, Region and Market columns. Then "unpivot other columns". You'll end up with a much lo...
Technically the first formula is correct. But if it will lead to the correct result when used in conditional formatting (CF) is another question. T...
PQ doesn't have a function similar to NETWORKDAYS in Excel. You would have to create your own method. Google for "working days power query" and you'll...