We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
|
By:
in col. B would it not be as simple as:
=if(a2=0,a1,a2) or have i missed something |
|
By:
That would work if I want to replace a2 with a1. The issue I have is there is between 2 and 10 zeros and i want it to replace with the last non zero value.
I hope this explaination is a little better. e.g. 2 0 0 6 0 0 0 0 7 0 0 becomes 2 2 2 6 6 6 6 6 7 7 7 Cheers |
|
By:
starting at b2
if(a2=0,b1,a2) You'll have to manually do the first line |
|
By:
Perfect cheers.
|