Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match Cells
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.worksheet.functions
|
|||
|
|||
Match Cells
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
Ensuring 3 cells do NOT match | Excel Discussion (Misc queries) | |||
Look for a value in two cells and match it with another | Excel Discussion (Misc queries) | |||
Match cells with cells on another workbook | Excel Worksheet Functions | |||
Query counting cells in a row that exactly match cells in another | Excel Discussion (Misc queries) |