Check your other post.

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

--

Dave Peterson