Last seen: Mar 8, 2026
Hello, Started to check my files where I know I have long text where many are 400+ characters and have luckily found no errors of this kind, in fac...
Hello, Looked around on this topic and found an explanation on this site: This behavior is determined by the the predictive nature of the Exce...
Hello, Can you share a sample file with some dummy data and also a mockup of what you want to achieve, that would make it easier to help you. Br...
Hello, Great that it works and thanks for your update, I have avoided such scenarious but with your example I see that it can actually work. Br,...
Hello, Normally you avoid to write formulas resulting in a circular reference, but there is an option to more or less allow such. See if enabling i...
Hello, Have you seen this article about get files from folder? Br, Anders
Hello, Thanks for the new sample file. Just wondering, did you check the modified sample file I uploaded in my previous post? I am asking because w...
Hello, I am sorry, but I can't follow your steps with the sample file you have attached. For example, in sheet Data, cell E8, the value is todays d...
Hello, It is easier for everyone if there is a sample file showing the data structure to look at, can you share such file? Br, Anders
Hello, In your sample file you write that in cell E5 you want the number three if the condition is false, but where does this three come from? Is i...
Hello, Isn’t it easier to use a Pivot Table to get the count or sum of each desired column for each solar system? Or enabling the total row for the...
Hello, What you want is dynamic dependent data validation lists and this link takes you to a blog post describing how to set it up. Br, Anders
Hello Hamid, Welcom to MOTH. In my view you don't need to involve Power Query to get what you want, but Power Pivot. I have created an example f...
Hello, Not sure I understand what your problem is, can you share a file with this problem? Br, Anders
Hello, If you also have the year then yes. Check out the Date.FromText function. Br, Anders