Forum Discussion
mathsteacher
Feb 24, 2024Copper Contributor
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...
- Feb 24, 2024
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
Feb 24, 2024MVP
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
Feb 25, 2024Copper Contributor
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.