Last seen: Aug 26, 2025
Hi Patrick, No file attached. regards Phil
Hi Andy, Please supply a file with a question so we don't have to recreate everything. See attached file for solution. I'm not following the...
Hi Chris, Yes, always best to include all scenarios 🙂 I just needed to make an adjustment to the loop counter in the function to this each [...
Hi Alexandra, no file attached. make sure you click Start Upload after selecting the file. regards Phil
Hi Peter, When you get an error that states aa key is missing it usually refers to a missing column, or a column that has been renamed, or a missin...
Hi Chris, I've written a function in Power Query that takes your Custom Column and then extracts everything up to the first number to character tra...
Hi Mazharul, Please supply a file with some sample data and an example of the results you are looking for. Regards Phil
Hi Lea, So the number 202104 is what you want to convert to a date? I assume that represents April 2021 so there is no day specified, in which cas...
Hi Nick, Try this =IF(A2="Expedia", S2*0.9, IF(A2="Orbitz", S2*0.8)) If neither of these conditions are met then the formula will return Fals...
No problem. Glad you got it sorted out.
Hi Steven, It's hard to understand what you are trying to do without seeing your files. Can you please attach some sample files including the qu...