survey

I conducted a survey and I am trying to return a value using index match. I am realizing that some of the text of the survey has been edited, so my index match isn't finding what it needs to. I thought I would have a better return rate if I instead of matching the whole cell, I would match just...

Hi All, I will try my best to explain my situation. I've a file with the following data: +------------------+------------------+------------------+------------------+------------------+ User Metric A Metric B Metric C Metric D...

I have a Survey of 17 questions regarding specific companies. I need to create a score for each company. The questions are grouped into 3 areas, weighting of 40%, 40% and 30%, using the Likert scale of 5 responses for each question. Based on the score of each area, I came up with where each...

I am trying to create a clickable survey/grading form and would like to have a red circle encompass a cells contents when selected as pictured below. Any ideas on how to make this work? I will have approximately 10 questions, each with the below graphic following it.

I am trying to make a yes no maybe survey Star Trek as Yes and Star Wars as No and No Pref as maybe. This is how far I have got I am also tallying the totals in field A1:C2 <tbody> A B C 1 Star Trek Star Wars No Pref 2 0 0 0 </tbody> Private Sub btnOK_Click() Dim intSelection...

Hello, I am using SharePoint to collect data through its survey feature. However, I want to make the output data more manageable. As such, I want to take the multiple columns and consolidate them into a few. Currently, it looks like this: Name 1 Address 1 Age 1 Name 2 Address 2 Age 2 Name 3...

Just found out about OneDrive's Excel Survey feature. Great... Is it possible to run some code to process the data as surveys are completed. Live and online that is, rather than having to do from desktop excel. Advice much appreciated.

Ok, I have a scenario that I have searched and searched on and have not been able to come up with a good solution. I'm really hoping someone here can help me. I have two items, a macro-enabled excel workbook and a sharepoint site survey. What I want to be able to do is... 1. Create a...

I'm trying to create a worksheet for a Luncheon choice in our workcenter. I would like to offer 4 choices, each user clicks on a choice and at the end I can calculate the winning choice. Maybe I haven't had enough coffee but I can't even remotely figure this out.

Hi all, I need help on a survey table that is of following format. Sr# contains 318 rows and there are 30 columns named 1 through 30. I want to create a summary using 'pivot table' that helps me in identifying how many questions have an answer 'a', 'b', 'c', 'd', and '0'. Would appreciate a...

Hey all, I am currently a student who is partaking in compiling my survey results. I want to pair the variables up in a row so that i am able to see a person's data more properly as shown by the table below. Ideally this is what i want to achieve. <colgroup><col><col><col></colgroup><tbody>...

My school district is moving from Google Apps to Office 365 and I am trying to find out if Office 365 will be able to accomplish a task. In Google forms I created a survey and after someone completed the survey a "script" was automatically run and it would take the responses and place it into...

Hey guys/gals, I followed a youtube video on setting up a survey in excel, and it works great, but it was only for two options. I wanted to make it 5 options per question, but when I started adding to the code ( which I thought was correct, but was not ) I kept getting errors. It probably is a...

I have a survey built, which I need to fill out 14 times. Each time the survey is filled out it needs to be on it's own worksheet. The survey, however, is still being refined, so I need any text changes to the root/master sheet to carry through to all the survey sheets. A microsoft query and...

Hello! I am super new to creating VBAs in Excel and in fact this is my first attempt. I am trying to create a survey and what happens is when someone leaves a spot blank when they submit the survey then a Message Box will populate advising that need to go back to that question and fill in the...

I've stretched my brain enough on this problem, figured I'd finally sign up and ask the experts. I have a set of survey data: <tbody> Submitter Q1 Q2 Q3 Q4 aaronchiles Pear Apple Banana Peach aaronchiles Apple johndoe Apple Pear Peach johndoe Banana </tbody> Each submitter can...

Hi All, I am having difficulty determining what type of formula to use for a problem I have. I have a range of surveys that include a start and end time on a specific date. I also have a spreadsheet with an extract of device availability. What I am trying to do is return a "Yes", "No" or...

Hello experts, Tried all methods without success I have large data of around 10,000 drainage pipe segments and 10,000 junctions in ArcGIS layer The problem is: due to some reason certain junctions could not be accessed for survey, thus 1,000+ entries are missing for pipes (up stream and d/s...

Can someone please help! I am creating a spreadsheet to analyze the data of a survey. For each question of the survey there are 5 options that can be chosen as an answer, and each of the 5 answers have a numerical value that correspond with them ie: Very Poor=1, Poor=2. Fair=3, Good=4, Very...

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...