Forum

Ooops. Forgot to attach the file.

It wasn't all that straight-forward and I'm not sure it my solution works correct all the time. Though, it does work with your example data. Althou...

What makes you say that? Is it because in the Q3 example both FALSE, FALSE and FALSE, TRUE give the same result? If so, that's just a coincidence. ...

Please note that the cell with the #CALC! error contains a formula that refers to the Region column. =UNIQUE(Table_2q[Region],FALSE,TRUE) Since...

The only solution I could come up with was to include line feeds (alt-enter) inside the cells with the labels and making sure that these cells are set...

The file you uploaded seems to have a values only version of the pivot table, including all departments. In order to look into your problem, I recreat...

Would be helpful if you could share some examples of the weekly and corrections files. Without disclosing any confidential information of course. But ...

Just in case you are using a modern Excel version, the formula below does all in one go, without the need of the 'helper formulas' in rows 6, 9, 12 et...

Thanks! I didn't see your reply until know, although I have been on-line every day the last couple of days. Who knows why? Anyway, you have already...

I wonder why you would capture time in separate sheets per project. It would be more effective to receive weekly timesheets from employees that contai...

As similar question came up not too long ago where a filter expressions were used inside a CALCULATE function, without explicitly using the FILTER fun...

No file was attached. Please try again and don't forget to press 'Start upload' (and wait a bit) before you submit your reply.

I'm sorry but don't understand. If you want to do something like this you need to have some logic that can be applied over and over again. I don't see...

Good to hear. Not a big fan of VBA anyway.

Sure, but the formula will become quite long and ugly. Which Excel version do you use?