Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Count exact matches
Hi! A bit frustrated, been trying everything but can't get it to work properly.
I have a World Cup prediction pool at work, and have in columns everyone's prediction, and in the 1st column I have the correct result column. I need the formula to automatically update the scores after each result I input into the result column. So far I have managed to get 48 using the DCOUNTA formula, but it always gives me 48, out 48 matches. Example Result Me Him X 1 X 1 1 2 2 X 2 Points 1 2 Because I guessed the right answer for the right row only once, while him guessed 2 correct answers in 2 corresponding rows. Please help me!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Routine to find exact Row matches in Col1 Col2 Col3 but exact offsetting numbers in Col4 | Excel Discussion (Misc queries) | |||
finding exact matches | Excel Worksheet Functions | |||
how do i get exact matches in a vlookup fomrula | Excel Worksheet Functions | |||
finding exact matches using vlookup | Excel Worksheet Functions | |||
data that matches exact column and row | Excel Worksheet Functions |