Comparing Data

S

Sharon R

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

Vergel Adriano

In C1, to compare A1 and B1:

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

copy down as needed..
 
Top