Thread: Comparing Data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Vergel Adriano Vergel Adriano is offline
external usenet poster
  
Posts: 857
Default 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!
Reply With QuoteReply With Quote