<?xml version="1.0"?>
<rss xmlns:media="http://search.yahoo.com/mrss/" version="2.0">
							<channel><title>New Posts For Thread: Excel Help</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25963725/excel-help</link><description>In Colum A I have a list of numbers - e.g2006000If the value is 0 i would like to replace it with the last non zero number from above. e.g2226666Any ideas? Thanks</description><item><title>Perfect cheers.</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25963725/excel-help?post_id=468373929#468373929</link><description>Perfect cheers.</description><pubDate>Fri, 01 Oct 2010 07:03:22 -0500</pubDate></item><item><title>starting at b2if(a2=0,b1,a2)You'll have to manually do the first line</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25963725/excel-help?post_id=468373617#468373617</link><description>starting at b2if(a2=0,b1,a2)You'll have to manually do the first line</description><pubDate>Fri, 01 Oct 2010 06:59:36 -0500</pubDate></item><item><title>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   0060000700becomes22266666777Cheers</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25963725/excel-help?post_id=468372965#468372965</link><description>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   0060000700becomes22266666777Cheers</description><pubDate>Fri, 01 Oct 2010 06:50:50 -0500</pubDate></item><item><title>in col. B would it not be as simple as:=if(a2=0,a1,a2)or have i missed something</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25963725/excel-help?post_id=468372701#468372701</link><description>in col. B would it not be as simple as:=if(a2=0,a1,a2)or have i missed something</description><pubDate>Fri, 01 Oct 2010 06:47:34 -0500</pubDate></item><item><title>In Colum A I have a list of numbers - e.g2006000If the value is 0 i would like to replace it with the last non zero number from above. e.g2226666Any ideas? Thanks</title><link>https://community.betfair.com/general_betting/go/thread/view/94082/25963725/excel-help?post_id=468372265#468372265</link><description>In Colum A I have a list of numbers - e.g2006000If the value is 0 i would like to replace it with the last non zero number from above. e.g2226666Any ideas? Thanks</description><pubDate>Fri, 01 Oct 2010 06:42:10 -0500</pubDate></item></channel></rss>
