Last seen: Jun 29, 2026
Hi Emma, Yes, it's the password. The only way around it is to write some VBA that opens the files, enters the password and then refreshes your quer...
No problem, Jay. Glad we got there in the end and next time it should be quicker and easier 🙂
Hi Dritan, You could use a custom formula in a data validation list, but my feeling is that it would be way too complicated as there are too many v...
Hi Jay, Thank you for clarifying. In future please take the time up front to make your questions this clear. It will save everyone time. In the ...
Hi Leah, Thanks for sharing your sample data. If you add a Filter to column A and then click the Filter drop down you can see that some of the d...
🙂 It's always nice to make a little discovery. Enjoy it.
Hi Revathi, The reason your formulas are too big and complicated is because your data in not in the correct layout, for if it were then you could u...
Hi Jay, So now you know your explanation needs to be this clear, please rephrase your second question and give context and examples. e.g. I don't k...
Hi Mey, Your question has remained unanswered for so long because it's not very clear. When posting a question it is best to not only provide your ...
Hi Jay, So, if your due date in cell A2 is 15th August 2017 then you want to sum the "in progress" values in column R that have a date less than 15...
Hi Jay, I don't understand the conditions you require. Please give an example of what dates you would sum the In Progress figures for, if the due d...
Hi Michael, To confirm, the official response from Microsoft is the download page should list Windows 10 as a supported operating system. They're g...
Hi Paul, To clarify, columns J:S contain the winning lottery numbers and columns B:G contain the numbers selected by each person. For someone to wi...
Ugh, they keep moving it! Thanks for letting me know. I've fixed the file now. Cheers, Mynda
Hi Michael, I'm not sure where you're seeing that, but I have Windows 10 and Power Query works just fine for me. On the Power Query download page i...