General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
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
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
Show More
in col. B would it not be as simple as:
=if(a2=0,a1,a2)
or have i missed something
=if(a2=0,a1,a2)
or have i missed something
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
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
starting at b2
if(a2=0,b1,a2)
You'll have to manually do the first line
if(a2=0,b1,a2)
You'll have to manually do the first line
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539