Your are my HERO!!!!! Thanks you so much for clearly understanding the need. I have tried multiple combinations and the formula works PERFECT!!!!! I had a good feeling that both the logic from the previous formulas could help make a resolve.
Now this last formula is the right formula: =IF(SUMPRODUCT(--((LEN(E3)-LEN(SUBSTITUTE(E3,CHAR(ROW(INDIRECT("48:57"))),"")))>(LEN(D3)-LEN(SUBSTITUTE(D3,CHAR(ROW(INDIRECT("48:57"))),""))))),"X",E3)=E3
Could you kindly explain the various elements of how it works as it is quite different, especially the part that shows CHAR and" 48:57" ?
Thanks again! :congrats::thumbcoo::thanx::cheers::yourock: