Forum

Hi Gary, I have checked your file and the array formula you have in cell H5 works. In case you want to change and use COUNTIFS then you can use fol...

Hello Mitul, As I wrote in a previous reply, you need to check the table header names in the Pivot Table. Your formula is: =GETPIVOTDATA("Order ...

Hi Kenneth, It is always much easier to understand if there is a sample data showing the scenario. Can you upload such file? Br, Anders

Hello Gary, There must be something wrong in your data or more likely, your file. As I try to show with below picture, with the criterias you menti...

Hello Mitul, I hope you're good. The easiest way to compare two columns and highlight the cells where you have same data is to select the range ...

Hi Mitul, I am confused. What is your question? Br, Anders

Hello Mitul, To start with, this article describes why you get a #REF! error and how you can correct it. Secondly, this article describes the GE...

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