• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Substitute 1 for correct answer and O for wrong answer

Louie Zabala

New Member
Hi friends! I need help substituting cells based on the answer key. I manually did the few tabs but there are still a lot more to substitute. I need your help for a formula to automatically update and substitute based on the correct answer. I attached the file for reference. Thank you in advance and God bless.
 

Attachments

  • SchijfCMNTrails-per-item (1).xlsx
    51.3 KB · Views: 9
You can't use a formula to change a plain value in a cell.
I'm not sure what you want, but in cell C2 of the LABAS STAND ALONE sheet put this formula:
Code:
=SUM(--(C$3:C$32='Answer Key'!$B$2:$B$31))
and copy to the right. It will tell the number of correct answers in the column below the formula.
 
Back
Top