I am trying to compare two columns of text on two different worksheets. How can I show or identify errors (misspellings, new names, etc.) and missing data? For example, comparing Sheet 1, column A, range 1-25 and Sheet 2, column A, range 1-25.
I would like to display any errors on sheet 1.
Any ideas would be greatly appreciated!!
Christal
I would like to display any errors on sheet 1.
Any ideas would be greatly appreciated!!
Christal