Forum

Hello, You should arrange your data in a tabular format. See attached file and make a Pivot Table of the rearranged data table, you should get corr...

Hello, I suggest you take a look at Power Query, it should be the right tool for what you want to do. Br, Anders

Hello, See if the info in this Microsoft support page gives any help. Br, Anders

Hello, I am afraid that my reply won't contain much help, but to get a sum per category using DSUM you need to add the category/-ies as a criteria,...

Hello, Welcome to MOTH. If you haven't found this resource page already so do take a look, it contains lots of Excel treasures. Resource Downloa...

Hello Yuyun, If you can upload a sample file with some dummy data so we understand what kind of data you have and how it is structured, it would be...

Hello Lea, Ceck this Microsoft article about #date function in Power Query. /Anders

Hello, Have you tried using the DATE function? You will also need to use the LEFT, MID and RIGHT functions to get the values for the date. =DATE...

Hello, I did notice an error in the formula I provided. Change the M in red below to N, and you have a correct formula. Night: =SUMPRODUCT((L2-K2)*...

Hello, Welcome to MOTH. If you upload a sample file I am pretty sure someone can help you out. Would also be good if you in the sample file also...

Hello Saliha, I see no formula in column E, what have you tried with? Where do you get stuck? Condition 1 - You can use SUMPRODUCT to sum the ma...

Hello, Not sure I really understand what you are asking, when checking your latest uploaded file from post no:4 I don't see any errors/issues. Woul...

Hello Dave, Seems the file didn’t get uploaded. After adding the file you need to click on Start upload button and then wait a few seconds. Br, ...

Hello, Do you have a sample file you can upload? Br, Anders

Hello, Can you add a sample with some dummy data so we can see how the data is structured and what the limitations are? Makes it much easier to hop...