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
<tbody>
</tbody>Thanks
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>
Last edited: