Last seen: Jul 6, 2025
Hello, In my point of view you need not to worry. With Excel 365 you get what Excel 2016 has and more. This support page lists all functions availa...
Hello, A sample file showing your data (not necessarily the real sales data) and what you are struggling with would be of good help here. Br, An...
Hello, I searched for the exe file and found this blog post, seems you get to live with it. Question: does it behave differently if you run the .Ba...
Hello, As you surely knows, the result all depends on what margin widths you choose, what row and column widths and heigths you have and so forth. ...
Hello, You can read more about using IF statements in Power Query here. See attached file and sheet With measure, is that something in line to w...
Hello, Ok, thanks for clarifying. In attached file I propose a different approach, it is simpler and dynamic. It requires though that you have P...
Hello, Well, my thought was that you could call the taskkill command from whithin your VBA code. Br, Anders
Hello, Not a really an answer to why these tasks are created, but you can always kill them if they are not needed. Br, Anders
Hello, It is not uncommon that I need to change the formatting code so it suits the Swedish formatting, I usually do that by changing the Y to Å. I...
Hello, Thanks for the sample file, makes it a lot easier to understand the issues. As I don't know what version of Excel you have, I have given ...
Hello, As this is your first post you might have missed the forum rules, but as stated you should add a sample workbook instead of a picture, this ...
Hello, Can you upload a sample file that shows the issues? Br, Anders
Hello, Don’t know if I understand how you want it to work, but I try to give you an answer. You can set a default value in the cell where you ha...
Hello, You can find great info and examples on how to write IF formulas in the blog section. Try this formula in D1. =IFERROR(IF(A1/B1=C1,C1,A1)...
Hello, If you haven’t already, do check out the blog section on this site, it contains lots of good and useful articles. See attached file. I used ...