Forum

Hello, This blog article by Mynda is perhaps presenting something similar of what you have in mind. /Anders

Here is a good list showing all Excel functions and from which version they are available.

Hello, With the current layout you can't avoid messy formulas, as you probably have guessed by now. As also already mentioned, I assume you will ha...

Hello, It has passed many years now since I worked with such financial data, so please correct me in case I am overlooking some aspects. Based on y...

Hello, The term ”break even” is for me how many units you need to sell to cover the costs. With this in mind you should use following formula: F...

Hello, Have you tried using the ISOWEEKNUM function?

Hello, I am not sure If this is the scenario you describe, but check this tip on how to ”reset” scroll bar in Excel. Br, Anders

Hello, Just a simple example attached where I am using VLOOKUP function. Check the highlighted cell. It is showing 96 but the underlaying value is ...

Hello, If you start Excel first and then when in the Open file view, choose the option to open and repair. But this is also no guarantee that it wi...

Hello John, Have you read this article on how update data from files in a folder using Power Query? I believe that is the best approach for you. No...

Hello Joseph, I notice that you have different delimeters, spaces and commas. That makes it difficult to maintain text such as street adress etc. I...

Hello, ’There is no file attached. Do check out these articles, they might give you the needed start. https://www.myonlinetraininghub.com/text-to...

Thanks Phil, This is one of the hazards using functions in a different language and then translating when posting.

Hello, Instead of setting a fixed parameter of 5 characters in the LEFT function, use LENGTH to check how many characters the lookup value has. Usi...

Hello, ’What is it you want? If you can give an example it will be easier to help you out.