Match function
Team in A1, selected team in B1
in C1
=IF(A1=B1,1,0)
??
Is that what you're looking for?
"Andy920" wrote:
I run football pool and am trying to find out how to make my life easier lol
I am looking for the formula I would need where I would put the winning teams
in column A, paste their entry into column B and have column C show a value
of 1 if it matched. Would appreciate any help Thanks in advance
Andy
|