copmare cotents of two columns and return dissimilar values
 

HI All,

I want to compare the content of each cell of a column withb each contents
of each cell of a different coulmn and return dissimilar values.

Thanking Your Feedback.
Shaukat

=EXACT will return TRUE or FALSE. If you are comparing data in Column A and
Column B, use =EXACT(a1,b1).


"Shaukat Hussain" wrote:

HI All,

I want to compare the content of each cell of a column withb each contents
of each cell of a different coulmn and return dissimilar values.

Thanking Your Feedback.
Shaukat