General Betting
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
sort by:
Show
per page
Replies: 4
|
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.
|