Looking for Matches
Options
Christopher Pretty
✭✭✭✭✭
I have two columns of data. One column I know is correct, the other has the same information but is a manual entry with possible human error. I am looking for a way to compare the two cells to see if the info matches. For instance the first column may have 220656 and the column next to it may have 220655. I need a way to highlight those different cells.
Tags:
Best Answer
-
I figured it out with an If formula.
Answers
-
I figured it out with an If formula.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!