Forum

I'll see how to upload but theres at least 100 files being combined the 142 or now 104 comes from power query adding a step when I click the error i...

Added file with identifying details removed, and I lied I just noticed Columns AB:AM will also need cleaning but they dont start with AM/M

Ahh thank you, dont recall changing that. Functionality like running a script from an event on close/open cell change selection change, userfo...

Turns out someone added Icons the the Parent folder that dont appear in the path but alter it enough to throw a 404 error thanks John

Thanks Anders, butr perhaps I wasn't clear. I want to find out what the value equivalent to the 4% in my example. i.e. Use the 1.5...

Awesome amazingly simple, yes I have 365 subscription and I obviously need to learn more about the new functions Thanks