View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default COMPARE 2 COLUMNS

In C1 enter:

=IF(A1=B1,"",B1)

and copy down
--
Gary''s Student


"CB" wrote:

Hi, I would like to compare Column A with Column B. Column A is my standard
and the values in column B should equal Column A. If column B is different I
would like to put the Column B value in Another Column in the same row. Can
you help me with this.

Thanks Chris