Hi there,
I need help returning the desired result in Column G. Not sure if to nest the IF and SUBSTITUTE formulas.
In the attachment I have two identical list (Text 1 and Text 2). If the values in Text 2 is different than Text 1, i would like the values in Text 2 to supersede the values in Text 1.
Thank you for any help.
Bookmarks