Your question is not very clear, but here is my best guess...

Are you looking for a formula to put in Column C that will see if whatever
(single character) is in Column B also appears somewhere in Column A and
return 1 for True and 0 for False? If so, give this formula a try...

=--ISNUMBER(FIND(B1,A1))

If this is not what you want, you will have to restate your question and
supply a lot more detail about what is in Columns A and B (what are the 1s,
2s, and Xs), what Column C is there for, and what you are trying to get from
them.

Rick


wrote in message
...
Hy,

I am trayng to do formula for sport betting. but i have problem with
1x and x2. How to make formula for this;
A B C
1 1 1
1 2 0
1 x 0
2 2 1
2 1 0
2 x 0
x x 1
x 1 0
x 2 0
1x 1 1
1x 2 0
1x x 1
x2 1 0
x2 2 1
x2 x 1

Fires column (A) is pick, second is result of game (b) a C is true of
false!!

Meny thank!