Last seen: Jul 22, 2026
Hi Tamara, Running the code in the last file you provided does not generate any errors. Could you please describe in detail exactly what it is y...
Hi Tamara, You need to add a 'trap' to check for the cell that is being changed. As you want to check the value in C6 when it is changed, you need...
No worries Simon. When you start using PQ a lot you see how awesome it is, it'll change your life. regards Phil
No worries Kathi, glad to help. Regards Phil
Hi Tammy, I'm not sure what you mean by i got some problems the first one is: when i use codes for another thing Can you provide the file you ar...
Hi Simon, The webpage appears to have changed since you wrote that query. Some column names have changed e.g. Wins instead of Win Runs, and some c...
Hi Pieter, It's because you're using Replacer.ReplaceText. So PQ is only looking to replace text, null is not text. If you use Replace.ReplaceV...
Hi Colin, When you have a duplicate in the Selection column, how do you decide which to keep? I can't see any logic to how this is chosen. If you...
Hi Emmanuelle, Are those dates actually stored as dates? Or are they text? If they are not stored as dates then they won't sort correctly. R...
Hi Pieter, I misunderstood. You can use this to replace null values but you end up with xxx instead which still needs to be dealt with. Not sure ...
Hi Pieter, I would merge the Office and GuestRole columns; select them both then right click one of the column headers and click on Merge Columns ...
Hi Simon, You say measure so you are talking about the result of a DAX calculation? There's no way to refer to the measure from inside the PQ ed...
Hi Vasim, If you change tolerances then you need to change the values in the lookup table that looks up the tolerance and the corresponding value (...
Hi Kathi, You can work out how many years until a person reaches 90 with this formula =IF((90-(B3+C3))<0,0,ROUNDUP((90-(B3+C3))/2,0)) ...