Forum Discussion
letter by letter comparison
- Aug 11, 2018
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.
- Haytham AmairahAug 06, 2018Silver Contributor
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
- Philip WestAug 05, 2018Iron Contributor
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.
- Mahmoud AlJammalAug 08, 2018Brass Contributor
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 ...
- Philip WestAug 08, 2018Iron Contributor
I've been trying to make that work for you tonight, but so far I haven't been able to. If i have time i'll try again tomorrow.
- Mahmoud AlJammalAug 06, 2018Brass Contributor
Thank you Philip,
This is what I wanted, only it was limited to 44 letters, kindly give me as much as you can, at least 10000 letters (ten thousand), that is to allow me to compare the contents of a small article.
It was great, however, if you can kindly add one function to this macro, that is to notify me if I exceeded the quota, meaning that if the column includes (for example) three letters "a", and I wrote four letters "a", then I get "a" in another column dedicated to those extra letters.
Thank you again ...