This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
My solution, someday I'll come back to this and try the macro approach!
Once I managed to work out the logic I wanted, the challenge became a lot simpler. A tricky one though!
Non-iterative macro solution attached.
Had to brush up on iterative macros but all in all a great exercise !
Hi! Here my solution :)
My solution (using Running Total)