Forums

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

General Betting

There is currently 1 person viewing this thread.
Stans
01 Oct 10 12:42
Joined:
Date Joined: 19 Mar 01
| Topic/replies: 49 | Blogger: Stans's blog
In Colum A I have a list of numbers -

e.g
2
0
0
6
0
0
0

If the value is 0 i would like to replace it with the last non zero number from above.

e.g
2
2
2
6
6
6
6


Any ideas? Thanks

Post your reply

Text Format: Table: Smilies:
Forum does not support HTML
Insert Photo
Cancel
sort by:
Show
per page
Replies: 4
By:
Texas Pete
When: 01 Oct 10 12:47
in col. B would it not be as simple as:

=if(a2=0,a1,a2)

or have i missed something
By:
Stans
When: 01 Oct 10 12:50
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:
conchords
When: 01 Oct 10 12:59
starting at b2

if(a2=0,b1,a2)

You'll have to manually do the first line
By:
Stans
When: 01 Oct 10 13:03
Perfect cheers.
sort by:
Show
per page

Post your reply

Text Format: Table: Smilies:
Forum does not support HTML
Insert Photo
Cancel
‹ back to topics
www.betfair.com