This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Extract results with question and guidance
#1
Hi 

Is there or has anyone worked out an easier way to extract the results on a single sheet in raw text that includes the:  Question ¦ Answer ¦ Guidance 

I see there is an output sheet but it doesnt have the questions and guidance included. 

I would like to conduct my own analysis and in my limited knowledge of excel the cyclic loops of data between the _output and question sheets doesnt help in putting the above together easily. 

Ta
Reply
#2
Hi, that's going to be difficult with the setup of the output sheet as you indicated. The guidance sheet does have an identifier, but if you want to use a lookup formula (VLOOKUP) you would have to put the identifier in column A for all values. Essentially, this is even a double lookup function, so you'd have to use something as described in https[://]www.excel-easy.com/examples/two-column-lookup[.]html. And even then, you'd still have to copy the questions into a single sheet. You could use a cell copy function (press '=' and select the cell from the other sheets ou wish to copy, and then drag down and correct where necessary) to make it a little faster.

It's clear though, that the tool was not designed with this in mind.
Reply
#3
(03-08-2021, 11:15 AM)robvanos Wrote: Hi, that's going to be difficult with the setup of the output sheet as you indicated. The guidance sheet does have an identifier, but if you want to use a lookup formula (VLOOKUP) you would have to put the identifier in column A for all values. Essentially, this is even a double lookup function, so you'd have to use something as described in https[://]www.excel-easy.com/examples/two-column-lookup[.]html. And even then, you'd still have to copy the questions into a single sheet. You could use a cell copy function (press '=' and select the cell from the other sheets ou wish to copy, and then drag down and correct where necessary) to make it a little faster.

It's clear though, that the tool was not designed with this in mind.

No Problemo, Rob, Thought I ask. Am so itching to make a web form out of this....
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)