Quote:
Originally Posted by Jacob Skaria
Can you elaborate; preferably with an example? How would you like to compare
the values?
'This is not a popup...
=IF(A1<B1,"Mismatch","")
--
Jacob (MVP - Excel)
"deepak" wrote:
how to apply Warning massage so that a wrning massage should pop-up while
comparing two mismatched values
|
If you considering case sensitiveness of strings use EXACT Function
=IF(EXACT(A1,B1),"","MisMatch")
Ex: "Strange" is not equal to "STRANGE"
all the best