LibO 184.108.40.206 Calc / XP
I need to compare a longer list of text being located in 2 colums on a row by row level To see quickly which rows have different values in both columns I used the EXACT function which, according the Help file, “Compares two text strings and returns TRUE if they are identical. This function is case-sensitive.”
Colum B contains the EXACT function
Column C and D contain in each row the text I need to compare
B3: Formula: =EXACT(C3,D3) Result: TRUE
C3: “Date submitted” (without quotation marks)
D3: “Completed” (without quotation marks)
What am I doing wrong?
Thanks for your help in advance.