Last seen: Jun 6, 2026
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)) ...
Hi Vasim, No need for VBA, you can replace your IF statements with a lookup =VLOOKUP(ABS(I6),$Q$4:$R$9,2,TRUE) See attached file for my solut...
Hi Vasim, Please state what it is that you want as a result. Please provide a workbook with code. An image isn't a huge amount of use if it m...