Forum

Hello, Thank you for uploading a sample file. What version of Excel do you use? Do you have access to the new dynamic array functions? If so then t...

Hello, There are good support articles at Microsoft, for example this one about sorting data in PivotTables or -Charts. At the bottom of the page y...

Hello, Can you please upload a sample file so we don't have to spend time trying recreate the file. Br, Anders

Hello, It was just an issue about number format. Excel removes leading zeros in numbers. In attached file you can see how I built the formula. If t...

Hello, No file attached. Try to upload again. Br, Anders

Hello, Yes, it can be done, you do need to wrap with INDIRECT for it to work. =SUMPRODUCT((Invoicing[[Invoice Value]:[Invoice Value]]*INDIRECT("...

Hello, I am no coder myself but it seems to me that this article is describing what you are looking for, on how to set up a drop down list allowing...

Hello, Welcome to MOTH! Thanks for the sample file, it makes it far easier to understand the issue and to find a solution. I understand it that ...

Hello, For the summary part you can use SUMPRODUCT. If you want this data in a PivotTable then you need to rearrange the source data to be in ta...

Hello, I assume you enter a value in cell 'DRS - VARIATIONS'!C6, for example VO1 and that triggers fetching of data from tab VO1, is that correct u...

Hello Jan, Welcome to MOTH. If you had read the forum rules you would have noticed that is expected to upload a sample file with relevant data. You...

Hello, Great that it works as you wanted. Br, Anders

Hello again, While trying to get to sleep I was actually able to think of a way to only get those values that belongs to the picked Cause, FC_High ...

Hello, I never said it would be easy to set it up, but see attached file for an example. You can add more data to the table and it will pick up ...

Hello, One can tell you have not glanced at the forum rules, if you had then you would know that uploading a sample file is a good way to get respo...