Last seen: Mar 8, 2026
Hello, Not sure what you have tried with, but this only need an empty row 1 and then an ordinary IF function to check if A2 is empty, if true then ...
Hello Andy, Very kind of you, even though I am not a star I gladly try to help. I’m sorry, I don’t intend to help you with a complete file or so...
Hello Andy, Attached is a simple sample file, it is not a final solution, but it gives perhaps a base to build on. With the given layout it gets mo...
Hello Andy, Thanks for the file. Regarding calculating the end time you should be able to crack that nut if you read the good information about dat...
Hello Andy, Seems the file didn't upload successfully, do try to upload it again. Br, Anders
Hello, If you have Microsoft 365, see this blog post on how to import data from PDF files. If you have older version then the easy method is to jus...
Hello Fred, You can reference to defined names in other workbooks, but if there is any new data in any of them you would need to open the other wor...
Hello Ethel, I have added two more columns, N and O, showing earliest and latest time for each date. I hope this gives you the help you want. Br...
Hello Brian, Attached is an example on how to visualize what needs to be checked and perhaps corrected using conditional formatting. Nothing advanc...
Hello Ethel, Welcome to MOTH. How do you want it to be presented? Highlighted using conditional formatting or using some kind of report form? Anywa...
Well, I am soon out of suggestions. Do you get any alert message in the Queries and Connections view for those queries showing null values? If so, wha...
Hello, If it works fine when refreshing one query at the time then I can only assume nothing is wrong with the queries. Might be that you've got an...
Hello, Do you get null when refreshing one query at a time instead of all at the same time? Br, Anders
Hello Dan, I am not skilled enough in Power Query to look for a solution using that tool, I have instead looked into highlighting the overlapping d...
Hello, Jessica has provided a nice solution with a pretty advanced formula. Just want to share that with helper columns you can simplify the formul...