mitchandsuzy
New member
- Joined
- Jan 5, 2016
- Messages
- 6
- Reaction score
- 0
- Points
- 0
Before I start - this is the reference I used on Ken's Blog - Calculate Hours Worked - Ref Blog 10th June 2015.
Thanks to everyone for sharing your knowledge!! I have bought M is for Data Monkey and Matt Allingtons Power Pivot book to try to teach myself how to use these great add-ins.
I have modified the Code that Bill Szysz allowed us to look at in the blog above.
It works okay but it duplicates all the results - I can get rid of the duplications in PQ using remove duplicates - but that offends me - I want to get the answer right the first time. (Watching too much Mike Holmes!).
Is there a debug mode?? I am sure it is an issue with the joining method but I can't find anything to help online or in the books.
I will attach the file that Bill created and I modified.
Thanks for any assistance you can offer.
Suzy
Thanks to everyone for sharing your knowledge!! I have bought M is for Data Monkey and Matt Allingtons Power Pivot book to try to teach myself how to use these great add-ins.
I have modified the Code that Bill Szysz allowed us to look at in the blog above.
It works okay but it duplicates all the results - I can get rid of the duplications in PQ using remove duplicates - but that offends me - I want to get the answer right the first time. (Watching too much Mike Holmes!).
Is there a debug mode?? I am sure it is an issue with the joining method but I can't find anything to help online or in the books.
I will attach the file that Bill created and I modified.
Thanks for any assistance you can offer.
Suzy