Last seen: Aug 22, 2025
Hi Arun, Sorry we don't do homework/assignments for people. We encourage you to learn to solve the problems yourself. Looks like you'll need to u...
Hi Patrick, You can get the first part of the address with this =IF(IFERROR(SEARCH(" Ste ",C2),0)>0,LEFT(C2,LEN(C2)-(LEN(C2)-SEARCH(" Ste ",C...
No worries Tamara
OK I think I know what you mean. The code you've entered is interfering with my code that checks the selection from the validation list. You just ...
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 ...