Oh dear - almost 24 hours, 40+ views and no replies - what have I done wrong?! In the meantime, I've been working on it, and have managed to start ...
You are a true superstar - I have no idea what I was doing wrong! Thank you so very much!!
Hi - many thanks for getting back to me! Thank you for your comments @Hans - please see file attached. The VBA was partly written by someone at Co...
That is amazing, Alan! Thank you so much for your help. Sadly, there's one last bug. PAYROLL_Structure returns 169 unique rows, but that increase...
Hi. Please find attached the output I get from my Power Query. I need it to remove duplicates on Personal Reference:People (column I) so that...
Oh no! It looks like I totally failed to thank you for your response - sorry and thank you! Sometimes it just takes someone pointing out the obvious...
Hi Jessica - thanks for responding. I thought I had future proofed it, by putting the data source as a folder, so I should just need to add the lates...