How to Compare cell contents in Excel

Hello friends,

Again I got data from client in excel sheet :) and This time I need to compare data from cell content .
and again I google for this and found one function
EXACT.

At official website I got below details, 

Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. Use EXACT to test text being entered into a document.

Syntax

EXACT(text1,text2)

Text1     is the first text string.

Text2     is the second text string.

We can check this with below example

A
Data
BD122
BD123
BD123
Formula	Description (Result)
=EXACT(A2,A3)	Compare contents of A2 and A3 (FALSE)
=EXACT(A3,A4)	Compare contents of A3 and A4 (TRUE)

Hope it will be useful  and save your time 

Enjoy the day with lots of smile and happiness.......