The following are the basics of using the SameValue UDF


The SameValue function provides a quick equivalent to the function =if(A1=A2,"TRUE","FALSE"), that checks if two cells have the same value.

The function returns 'TRUE' if the cells are the same, otherwise 'F'. The 'F' was chosen over 'FALSE' as the difference in length between 'F' and 'TRUE' makes it easy to scroll down a list and see the mismatches.

The syntax of the function is:

=SameValue(valueA, valueB)


where

valueA can be a string ("happy happy") or cell reference (A1) representing the value to be checked against valueB.

valueB can be a string ("happy happy") or cell reference (A2) representing the value to be checked against valueA.


graphic


Example:

graphic

  

Created with the Personal Edition of HelpNDoc: Easily create EBooks