Last seen: Jul 6, 2025
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...
Hello David, It is always better if you also upload a sample file. What Excel version do you have? If you do not have 365 version then you most ...
Hello, Power Query operates on given instructions, so it needs data that identifies what rows to keep. You seem to be able to tell as you describe ...
Hello Craig, In attached file you will see an example of, in my view, a better approach to handle the data. This is just an example aimed to show h...
Thanks Velouria! I learned a new use of SUMPRODUCT. Br, Anders
Hello, Based on your formula, where you check if the dates in column H is less than or equal to the date in cell E21, the result of four is correct...
Hello, This formula works between rows 4 and 227. If you highligt certain part of the formula, for example (ROW()-4) and then press F9 you will ...
Hello, That would be great. There are more than one solution in Excel to get what you want and with VBA you can of course create more. I hope I gav...
Hello, Please see updated attached file. Br, Anders
Hello, I would suggest that you gather the data in a tabular format, as you then can use that data to feed Pivot Tables / dashboards. Gives you lot...