Forum Discussion
letter by letter comparison
I think I've done.. I hope so anyway.
Hi Mahmoud,
Please find the supposed solution in the attached file.
Regards
Thank you Haytham,
I found no solution in the attached file, no formula in any cell.
Basically, we should have a column with text, and once we paste text in a certain defined cell, the same letters disappear from the column (or change cell filling color).
Thank you.
In fact, there is a formula in the worksheet, but it's hidden in a conditional formatting rule.
=IF(AND(COUNTIF(C:C,C1)>1,COUNTIF($C$1:C1,C1)=1),TRUE,FALSE)
It seems that this isn't what you want, I think I didn't understand your question well, so I'll try with another solution and refer back to you if I got it.
Regards
I'm sure there are better ways of doing this, but.. i think this works.
Its a macro (can i attach a macro enabled sheet?) that just cycles through each letter in the text you paste/write and then deletes the first instance it finds in a table called Text_to_check.
You could probably edit the code to run without the button, but it seemed ok like this.
Dear Philip,
Many thanks for your valuable answer, I was mistaken, your solution is actually not limited to a certain value, it works with the value of pasted text ...
It is what I wanted, but I need you to kindly modify it slightly so the values in column F includes only the extra values ... kindly see the attached photo.
Thank you and have a great day ...
