hi guys, i have a large database full of names in two columns, lets say A and B which i had to type in a remark. For instance, if the name in cell A1 matches or is the same in cell, I put in a remark in C1 as "correct" instead of TRUE and "wrong" instead of FALSE. I know of the TRUE/FALSE formula but how do i automatically replace those results with my own texts which are correct/wrong.
please help here. thanks