Forum

Hello, Go to Data menu, on the left hand side you find From text, click on that and the Data import guide starts. Navigate to your .txt file and op...

Hello, For more in deapth guidance on how to use Conditional Formatting, please check this blog post, it covers the most you should know. As I d...

Hello, Notice when opening the .txt file following your steps that number values containing period (.) is regarded as text while those only contain...

Hello, I assume you also made the ALL query as a connection only. If so then you need to right click the query and choose Load to... option and the...

Hello, Have you considered using Power Query to import the data from the SharePoint list? Br, Anders

Hello, I don't know how familiar you are with Pivot Tables, but in attached file is a simple example where I have the data in an Excel table and th...

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