In the example in the Excel spreadsheet in row 2 to 5, the solution of the words were recorded by different players. In line 10 you will see the correct solution. Using a formula is now to be determined which player has found the correct solution.
Cells compare in excel
So you compare a cell (the solution word of the player) with another cell (Right solution)
In order to compare the solution word of the player with the right solution, you can use the Excel function IDENTICAL to the Syntax “the same(Text1, Text2)” This function compares the “Text1” value that is specified with “Text2”. For example, you check with the following procedure whether the solution word by Katja agrees with the correct solution:
- In line C2, the function is IDENTICAL with a formula: =IDENTICAL(
- In the first Argument of the formula, you make a note of the first one, so Katie's, solution. This is in cell B2: =IDENTICAL(B2
- As the second Argument, you specify which cell to compare Katie's solution to. In the example, this is the right solution in cell B10: =IDENTICAL(B2;B10)
- Confirm the formula with >>enter Enter
YOU MAY ALSO LIKE
0 COMMENTS
LEAVE A COMMENT
RECENT POSTS
The Role of Statistical Arbitrage in Quantitative Finance
Thu 20, 2025
From 'Da' to 'I Do': A Gentleman's Roadmap to Marrying a Ukrainian Woman
Thu 20, 2025
Integrating Cobot Arms with AI: The Future of Smart Manufacturing
Thu 20, 2025
