If (2 numbers in cell are identical) print "1" or "0" in cell "x"

[Alnicoll]

I can't seem to find an answer to this can anyone advise me please?
I want excel to recognize if column A row 1 has identical numbers (or text), print "1" in column B row 1. Else, print "0".


For instance
A _____________B

3 3	1
5 9	0

<tbody>
</tbody>

Thanks

 

[NeonRedSharpie]

...

=if(a1=b1,1,0)

...

 

[Sanjeev1976]

I can't seem to find an answer to this can anyone advise me please?
I want excel to recognize if column A row 1 has identical numbers (or text), print "1" in column B row 1. Else, print "0".


For instance
A _____________B

3 3	1
5 9	0

<tbody>
</tbody>

Thanks

Try =IF(LEFT(A1,1)=RIGHT(A1,1),1,0)

 

[Rick Rothstein]

If you only have two single digits in each of the cells...

=0+(LEFT(A1)=RIGHT(A1))

otherwise...

=0+(LEFT(A1,FIND(" ",A1)-1)=MID(A1,FIND(" ",A1)+1,99))

 

[Alnicoll]

Thank you for replying. I will try these and report back.
Thanks again