Z zorans New Member Joined Nov 14, 2003 Messages 32 Oct 27, 2006 #1 Hi I have list A1=Peter A2=0 A3=0 A4=John A5=0 A6=0 A7=0 A8=0 A9=George I want to B column looks like: B1=Peter B2=Peter B3=Peter B4=John B5=John B6=John B7=John B8=John B9=George Can anyone help? Best regards
Hi I have list A1=Peter A2=0 A3=0 A4=John A5=0 A6=0 A7=0 A8=0 A9=George I want to B column looks like: B1=Peter B2=Peter B3=Peter B4=John B5=John B6=John B7=John B8=John B9=George Can anyone help? Best regards
Jon von der Heyden MrExcel MVP, Moderator Joined Apr 6, 2004 Messages 10,806 Office Version 365 Platform Windows Oct 27, 2006 #2 Hi, In B1: =A1 In B2: =IF(A2=0,B1,A2) copied down to end of range. Regards, Jon