Forum Discussion
Solved
letter by letter comparison
Hi everyone, I need to compare the contents of a cell with a certain column. Let say we have a column with one character in each cell, I need excel to erase/delete (or change the filling color of) ...
I think I've done.. I hope so anyway.
So, you have the phrase split on letters located one by one down in column. When you type same phrase in another cell you'd like to hide letters in columns if no mistakes and keep visible typos. Like this?
Yes ... exactly ... the fixed text is inside the column, I want the test text (of the cell) to be identical with the target text (of the column), the exact same letters, but not necessarily the same order.
If somehow I could get an error message if (for example) I entered (W) in the cell while all the (W)s of the column were already consumed, that would be great.
Thank you ...
