Last seen: Mar 8, 2026
Who knows, but great that all is working again.
Hello, Something is wrong with your month headers for the P4 section. Choose to clear the cells and type in the month names again and you are on th...
Hello, There are of course other ways to achieve this, but as Purfleet mentions, it is not straight forward solutions and above all, not so dynamic...
Hello, Have you read this blog post? It should help you with what you want. Br, Anders
Hello, In my view the Pivot Table solution is better than a formula based, but in attached file you will see an example of the two solutions. The h...
Hello Daniel! Thanks for the link to the file. Yes, you had just forgot one simple detail to get this to work. See step 5 in this article, it menti...
Hi Daniel, Seems you missed a step when uploading the file. There is a short video here guiding on how to go about. Br, Anders
Hello, I don't know if this issue is related, but fun things do happen in Edge if browser zoom is other than 100%. Br, Anders
Hello, The picture is broken. It is better if you can upload the Excel file. Br, Anders
Hello, Not sure how you expect to get a good spot on answer when we don’t even know the setup. It would be great if you have a sample file to share...
Hello, In order to substitute several characters you need to nest the SUBSTITUTE function per character/word you want to change. You can read more ...
Hello Deepan, I have difficulties to see what you want help with, there is only one interest rate in your sample so what is there to differentiate?...
Hello, How do you save as space delimited file? I assume you use Save as and then choose.prn as file format. If so and that no longer works then I ...
Hello, Have you tried the tip from this blog post? It shows how you can use Power Query to compare two lists. The example in the blog post is of co...
Hello, See attached file. The easiest thing to do is to either insert a slicer to your table, see Full Data Input sheet for an example, or to use a...