Last seen: Jul 6, 2025
Hello, If you rearrange your data as shown in Data (2) sheet you can easily get what you want with a Pivot Table. I have not created such Pivot Tab...
Hello, If you search the Internet for ”alternatives to dynamic array functions” you will get some useful sites to check out. Br, Anders
Hello, Another almost identical formula where we skip the frequency part is something like this. =SUM(IF(MATCH($A$3:$A$10,$A$3:$A$10,0)=ROW($A$3...
Hello, I am confused Saliha, in my eyes you have a subtotal already. But if it is the 1,800 result you want, then do a minor change of Lionel’s for...
Hello, I believe that the data behind the headers This week and Total as of this week are based on dates, not text values. If you can get hold of t...
Hello, Issues like the one you have with column G not copying the formula down is often related to some error/issue on the worksheet or in rare cas...
Hello Edward, If you can elaborate on what issue you have, even better if you can upload a sample file where the issue is clearly shown, so that we...
Hello, Great job! I am just glad that I could give you some assistance. Have a great day! /Anders
Hello, Sorry, English is my second language and I may have missed some nuances in what I wrote to what I tried to say. What I tried to say was that...
Hello, I have some questions. Where do you want to add a row? What is the issue when adding the row where you want it? What was suggested that d...
Hello, The file seems broken, I can’t download it. Go to the blog section and search for running, you will get some articles to read. Here is on...
Hello, The photo is not showing a Pivot Table, it is just a range of data. As per the picture the data is manully entered in the cells, at least th...
Hello Fred, Not sure if this is a good approach in the long run, but at least it works with this small amount of data, even though you have to upda...
Hello, In the Excel table, change all Yes values to 1 and the No values to 0, then change calculation in the Pivot Table to sum the values instead ...
Hello, If you are interested to learn then I do recommend Mynda's Power Query course, it is well worth the time and money you spend to learn the ba...
