Forum

Hello Ishan, Check out this article from Microsoft, I am pretty sure you will find your answer there. Br, Anders

Hello, There is a big treasure hidden in this site which we refer to as MOTH, that is all the rich and excellent explanations of Excels functions a...

Hello, If by table you mean Excel table and not a range, then use SUBTOTAL. Check these pages for more information. Br, Anders

Hello, In Sweden and in UK you don’t need to request for such, you’re work gets copright protection when it is published. More info here related to...

Hello Rosemary, I suggest you check the minimum requirements in this page. The more data you are working with the more RAM is beneficial. If your c...

Hello, There is a good Excel Nested IF functions explained from Mynda about nested IFs, check it out. Br, Anders Sehlstedt

Hello, Take a look at this page, should give you the answer you look for. Br, Anders Sehlstedt

Hello, I can't see why it should not apply in Europe as well, there are after all many companies selling template files or tools to be used as add-...

Hello Mitul, I can't find anything wrong in your file, for me it works as you want it to, as long as I don't type in only numbers or try to write a...

Hi, You probably know this already, but I give you this tip in case you haven't thought about it. A simple way to get correct code is to record ...

Hi, As I don't write VBA myself I am not really correct person to give advice, but I do know enough to be able to understand what the code is suppos...

Hi Amy, I need to revise my previous reply. As Sunny writes, it does not work to add TRIM() as I mentioned. I am sorry for that. I set up a test fi...

Hello Amy, Yes, it should work just fine. Just give it a shot. =TRIM(SUMIFS('4_Std'!J:J,'4_Std'!G:G,A:A,'4_Std'!H:H,B:B,'4_Std'!X:X,$H$4)) Br...

Hello Lasse, Without any sample file that shows how your data is setup one can only assume and that is quite often not so good. My first thought wh...

Hello, I suggest that you take a look at this blog post and then adapt the code you see being used to your need. It is a good way to learn new thing...