| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match function
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Match function
That did it, sheesh I was looking in help for Match and was showing examples
using yen lol Thank you very much JLatham Very much appreciated and just saved me easily at least an hour a week lol Thanks again Andy "JLatham" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Match function
I don't understand what this means...
paste their entry into column B "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Index Function/Match Function | Excel Discussion (Misc queries) | |||
| Match as well as does not match array function | Excel Discussion (Misc queries) | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Hybrid Mode
