18 Nov
2011
18 Nov
'11
7:35 p.m.
Put this statement in C1 (assuming C1 is the first data cell in column C), =if(A:1 = B:1, A:1,"") then copy this formula down the entire column using Excel's copy /paste feature. (should auto adjust for cell names). Then in D1, =if(A:1 <> B:1, B:1,"") Then you copy this if statement in each of the cells in the D colum as above. :) Julie Clyde On Fri, Nov 18, 2011 at 7:11 PM, Chuck Hards <chuck.hards@gmail.com> wrote:
A pencil works extremely well, especially for such a small data set. ;-) _______________________________________________ Utah-Astronomy mailing list Utah-Astronomy@mailman.xmission.com http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy Visit the Photo Gallery: http://www.slas.us/gallery2/main.php