Assuming two columns, Col. 1 is Col. A and Col. 2 is Col. B. This assumes that Columns A and B contain number formatted data and not text formatted data. Columns C and D are computed. Fill down formula for column C for number formatted data: =IF(A1=B1,A1,"Null") Fill down formula for column D for number formatted data: =IF(A1=B1,"Null",B1) Use find and replace to replace test string ``Null'' with a blank. If Columns A and B contain text formatted data, use the following fill-down formula variants: =IF(VALUE(A1)=VALUE(B1),VALUE(A1),"Null") =IF(VALUE(A1)=VALUE(B1),"Null",VALUE(B1)) - Clear Skies - Kurt