Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I am trying to collate results from an online questionnaire.
I have a list of all possible field names in column A. I then import the results of a submitted questionnaire - these come in 2 columns and I place them in C and D. D cotains the data/responses and C is the corresponding field name. Unfortunately questionnaire fields that are not answered do not produce anything in column C (ie return no field name) thus I need to match up the data in D with the corresponding field in A. The only was I can see doing this is to devise a formula that searches column A for the fieldname in say C1 and then copies the data from D1 to B(number) i.e. adjacent to the correct fieldname in A. The formula would then be run through column C. Any help? Thanks to those suggestions earlier... I felt a little further explanation was required! Regards, Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Move column values w/o formula | Excel Worksheet Functions | |||
Move the last entry in a column to a different cell, when the loc. | Excel Worksheet Functions | |||
How to move one piece of text to another column | Excel Discussion (Misc queries) | |||
text from one column into multiple columns | Excel Discussion (Misc queries) |