Forum

Anders Sehlstedt
Anders Sehlstedt
@sehlsan
Noble Member
Joined: Dec 7, 2016
Last seen: Mar 8, 2026
Topics: 8 / Replies: 978
Reply
RE: Microsoft.Mashup.Container.Loader.exe kills Excel after queries refresh

Hello, Well, my thought was that you could call the taskkill command from whithin your VBA code. Br, Anders

5 years ago
Forum
Reply
RE: Microsoft.Mashup.Container.Loader.exe kills Excel after queries refresh

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

5 years ago
Forum
Reply
RE: Project Management Dashboard - Sequence of dates error

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...

5 years ago
Reply
RE: Automatic update of Information from One sheet to another sheet in One Excel.

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 ...

5 years ago
Reply
RE: XLOOKUP and search from last to next cell with value

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 ...

5 years ago
Reply
RE: Question abault Layout Features (format) of Pivot Tables

Hello, Can you upload a sample file that shows the issues? Br, Anders

5 years ago
Reply
RE: Default in Data Validation which is built by a table

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...

5 years ago
Reply
RE: NEED TO CALCULATE SOME VALUES USING LOGICAL FUNCTIONS

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)...

5 years ago
Reply
RE: Problem with hours summary

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 ...

5 years ago
Reply
RE: Filter in power query by today

Hello, Check out this function. Br, Anders

5 years ago
Forum
Reply
RE: How to use IF INDEX MATCH and REPEAT function

Hello, I am sorry, I didn't think it was possible, but I am even more confused. Your cell references does not match with what is shown in your samp...

5 years ago
Reply
RE: Multiple Price matrix

Hello, Are you sure Excel is the best tool for such tasks? You can of course use Excel, but there are more adequate tools out there, just search...

5 years ago
Reply
RE: How to use IF INDEX MATCH and REPEAT function

Hello, I am sorry, I don't understand what it is you want to achieve. Can you elaborate more? Br, Anders

5 years ago
Reply
RE: Need strong query to calculate profit value

Hello, Yes, the data also seems to be part of a training excercise. You can join data using relationships and Pivot, as Mynda writes in her reply, ...

5 years ago
Forum
Reply
RE: Help with Extracting Multiple Data from Excel Sheet

Hello, Have you tried using a Pivot Table? That would be my option to use. Br, Anders

5 years ago
Page 31 / 66
0