Hello,

How about a simply IF formula?

=IF(A1=B1,"1","0")


HTH,
JP

On Oct 19, 2:30 pm, Leon wrote:
Can anyone help me with using this feature. I am trying to compare data in
one column to data in another and place a 1 in another column to sort by
later. Thanks