Forum Discussion
MS Forms If function ignoring new data
Hello, I have a MS form setup collating information, I need to then reformat how this data comes in so it can be copied directly into another bit of software. Currently we have sheet 1 as below whic...
Hi, thanks for above - I tried above but just got a #CALC! error in the cell
Can you please share a sample sheet link?
Typical Forms response in Excel looks like attached. First 5 columns are always the same, next are answers on form questions.
