Forum Discussion

mathsteacher's avatar
mathsteacher
Copper Contributor
Feb 24, 2024

HELP! Formula not working

I am trying to create an excel sheet that I can use to analyze data from a multiple choice test. I have created a sheet, "Student Responses" that marks the exam once I enter student data and includes...
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 24, 2024

    mathsteacher 

    In 'Student Lesson Data'!E4 you call in formula Student Responses'!I6:M6 and after that add implicit intersection '@' in front of them. That returns !Value# error, rows 6 and 4 are not intersected.

    Not sure what you try to do. In brief, '@' is only for values in the same row of this or another sheet.

     

SergeiBaklan's avatar
SergeiBaklan
MVP

mathsteacher 

In 'Student Lesson Data'!E4 you call in formula Student Responses'!I6:M6 and after that add implicit intersection '@' in front of them. That returns !Value# error, rows 6 and 4 are not intersected.

Not sure what you try to do. In brief, '@' is only for values in the same row of this or another sheet.

 

mathsteacher's avatar
mathsteacher
Copper Contributor
Feb 25, 2024

Thanks! SergeiBaklan 

 

I did not have the @in my formula initially, but when I only had the first column, it created a spill into the next column which I did not want. I have taken them out and the formula is working the way I want.