• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

HOW TO FIND THE DIFFERENCE BETWEEN VALUES IN SAME CELL?

bharath

Member
HI,

I ATTACHED THE FILE
CELL A1= -1,-,1,-1 RESULT IN CELL B1 =" OK "
CELL A2= -1,-2,-1 RESULT IN CELL B2 = "NOT OK"

PFA

THANK YOU
 

Attachments

  • DIFF IN SAME CELL.xlsx
    11.1 KB · Views: 6
Hi,
You can use the Text to Column option to split your data in separate columns using comma as Delimiter, or the similar with following formula, to be entered in G2, copy across and down:

=TRIM(MID(SUBSTITUTE($E2,",",REPT(" ",LEN($E2))),(LEN($E2)*(COLUMN(A1)-1))+1,LEN($E2)))

Then you can easily differentiate between these results with simple COUNTIF or AND function.

Regards,
 
hi,
as you said, i copied the formula in g2
but not getting required result
i attached file (with using formula)

Better to using formula instead of text to columns option.
may characters length increase..
 

Attachments

  • DIFF IN SAME CELL.xlsx
    11.6 KB · Views: 3
In G2, copied down :

=IF(ISERR(-SUBSTITUTE(SUBSTITUTE(E2,LEFT(E2,FIND(",",E2&",")-1),""),",","")),"OK","NOT OK")

Regards
Bosco
 
Back
Top