Forum Discussion
MS Excel formula "skips" row based on input from MS Forms
Since the RawData is in fact an Excel Table, I think the formula could be rewritten so as to accommodate the size of the table--the number of rows in each column--automatically. It would do this by referring to the column heading rather than to specific cells.
But maybe we could "back up" and look at the overall process here: are you in the end wanting to get averages of responses to each question. Describe, if you will, the full process, what the goal is. Are all the questions ones with the same four possible responses? Etc.
Finally, is it possible for you to post a copy of the spreadsheet?
Thank you for your response!
The document is directly connected to my Microsoft Form, since it was created through "forms for excel" in sharepoint.
Every time a new response is submitted, a new row is added to the "RawData" table. What is want to achieve is: making the formula in the separate sheet reference the correct row, without having to "drag" the formula downwards manually.
The issue is that every time a new row is added automatically, the row is not added in the separate calculation sheet.
All questions have the same possible responses, and I would like to be able to measure averages etc.
The xlsx file type was not supported for uploading a sample, but perhaps there's another way of doing it?
joakimgg Hello, my spreadsheet continues to skip. Was there a resolution provided?
The xlsx file type was not supported for uploading a sample, but perhaps there's another way of doing it?
I'm sending you a personal message. You should be able to respond to that message directly to me, attaching a copy of your file to that response, sending it back to me that way.
Look for it by clicking on your avatar at the top right of this forum page.
- Thanks! I've sent a copy of the file to you now.
