Forum

Perhaps you can upload a file with all of this. Quite a bit of text and formulas to read through and difficult to follow if one doesn't see it in cont...

Please clarify which averages you expect to see if you were to calculate them manually.

I assume that whenever you enter a number in T, it's always the same as the total in S. Otherwise you can never count he pairs issues by size. In t...

Unfortunately, the screenshot didn't load. Please try again. This time, press the 'Start upload' button, wait until it's finished before pressing Subm...

Don't think that's possible with regular Pivot Table. Have even looked at Power Pivot with a DAX measure. you can suppress the yearly percentages but ...

According to the MS support pages, the new "in-cell" checkboxes are E365 (PC, Mac and Web) only.

Glad I could help. Keep learning!!

Well, if you don't want VBA but do have Excel for MS365 (as Hans suggested) you could create separate tables for each Site where you do all the change...

I was actually going on auto-pilot here, doing what I always do without much further thought about alternative solutions. The attached file now inc...

Wanting the Master to update the site data and vice versa would require VBA, I believe. And that's something I stay away from. Why not create a sep...

Not sure I got it right, but looking at the Expense Data, the attached file contains a query that I would want to create before analysing the data. If...

You were almost there. Although, I would have done it only a little bit different when it comes to splitting the date and time as demonstrated in the ...

Possible? Yes. But why? Without having seen your file I would say that it's best to keep all in one structured table and then create summaries per ...

The attached file contains a workaround as I believe you can't just tweak the technique used in the original file. I've kept the data from Mynda's ...

Have a look at this blog post. It explains how to combine multiple worksheets in on eworkbook.