ExcelBanter - Comparing Data

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

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

- - Comparing Data (https://www.excelbanter.com/excel-discussion-misc-queries/134454-comparing-data.html)

Sharon R

Comparing Data

I need to compare two columns of data, side by side, can you please give me a
formula? Thanks!

Vergel Adriano

Comparing Data

In C1, to compare A1 and B1:

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

copy down as needed..

"Sharon R" wrote:

I need to compare two columns of data, side by side, can you please give me a
formula? Thanks!

All times are GMT +1. The time now is 07:03 AM.