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:
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.
Created with the Personal Edition of HelpNDoc: Easily create EBooks