ExcelBanter - COMPARE 2 COLUMNS

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - COMPARE 2 COLUMNS (https://www.excelbanter.com/excel-discussion-misc-queries/92716-re-compare-2-columns.html)

Gary''s Student

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

All times are GMT +1. The time now is 12:27 AM.