Thank Mynda!
Hi Mynda, Thanks so much for the reply, these are very interesting options. So, the options you have mentioned above, will there be any issue wi...
Andy, I am glad the formula worked for you and gave the results you are looking for. As for your question on the staff database, I have not come...
Hi Andy, Firstly, welcome to this great forum, you will find great help and knowledge here. I had to rearrange your tables on each sheet as per ...
Hi Mynda, I have had sometime today to review your example and I like what you have come up with. I am having issues getting to the result I wan...
Hi Mynda, Thanks for your reply and your example which I will review. Sorry I have taken so long to reply, I was pulled into another project and on...
Hi Sunny Kow, Thanks for the reply. This has helped me get the results I needed, plus I have worked out the second part of the getpivotdata formula...
Sorry, I thought I added.
Hi Mynda, Thanks for your attachment. I did not think about adding a time group column heading with an if formula to each row, but this did th...
Hi Mynda, Thanks for the reply! Actually no, I want to keep the values as they are shown, as per my example on "Final Outcome", I want to sum al...
Here I have attached the actual data file and pivot table, I have taken out sensitive data. The pivot table is on tab "WO Pivot - Austin" and the d...