survey

Hi, I am completing a survey on excel in which I ask a number of questions. I would like to unhide and leave rows hidden based on User selecting Yes or No If No is selected from dropdown list (Yes or No Can be Selected) in row 13 it leaves row 14 to 24 hidden, but if Yes is Selected it will...

Hello, we are running 3 surveys and we would like to compare how many new participants we are getting each time. We have 3 sets of email addresses from each survey. I will really appreciate your help on that, Thanks!

Hi all, I'm trying to build a pivot on data from a survey. The survey is very simple in that respondents were just asked to rate 5 different items on a scale from "not important" to "very important." I want to build a pivot that has a column for each survey item and a row for each of the 5...

RE: Formula help Hi All I am after some help if you dont mind.. I basically have a sheet called "Survey's & Checklists" and within that I have a Cell E3 (PS Survey Completed) for which I would enter "Yes". I also have another cell in that sheet (PS Survey Completed Date) G3. I also contains a...

Hi there, I’m hoping someone here can help with this. I have two sets of data that I want to match up. One set shows me when a person used an app: The other set shows me when the same people answered a survey (about the app): I need to know how to put these two sets of data together...

Hello I want to count only the rows that contain at least one cell of data (text OR numbers), within a specified range of columns. However, I don't want to specify the range of columns using their fixed column letter names, but using the text in row 1 as the column header. (This Row 1 text is...

Hi I've been pulling my hair out for hours trying to figure this out with no luck. I am collating data this is pulled in via a Google Survey to a Google Sheet. When the survey gets a submission it adds a new row so I have used the INDIRECT and COUNTIF formula on a separate sheet to count the...

Hello! I'm making a survey that requires a response on every question. I have everything coded in VBA so that when an answer is selected on a check box all results are tabulated. However, I'm at a loss as to how I would create a button that interrogates the entire survey to ensure an answer has...

I will apologize up front. I am not a VBA guy. I have modified some code in the past but even with what I am finding here I can't seem to put it all together. What I have is a site survey where techs need to add pictures into one particular sheet. I need to accomplish the following: Import...

I'm trying to produce an excel chart to show responses to a survey from two different sources. e.g. What trends do you think are permanent or temporary? Apples - P,T,NS Pears - P,T,NS Now there are results from a National survey and then results from Local survey. The options people select...

Hello, I have received a spreadsheet with survey results and many of the questions have multiple answers in multiple columns. For example: <tbody> Respondent Where do you keep the product? a@gmail.com Home Car b@gmail.com Work c@gmail.com Home Car d@gmail.com Rental...

I have situation where we have an ongoing survey where the survey file needs to be merged with a master member table to bring over certain fields (age, gender, ethnicity, political affiliation) in the survey table for analysis. I tried to create a one to many relationship in Access and PQ but...

Hi, I have limited excel knowledge and I am not sure how to tackle this task. I have a survey that is for mentors and mentees wanting to participate in a mentoring program. I want to compare the responses from the mentees against the responses from the mentors to see how compatible the two...

Good morning, I am trying to use sumif and/or vlookup to solve my problem in my worksheet and there are too many variables for my expertise. The data is set up like this: <colgroup><col><col><col><col></colgroup><tbody> <tbody> A B C D Eng Hours Survey Hours Rate Total 8 0...

My organization conducts a survey of 75 companies and currently processes the results and generates the report using SQL. The process is about 20 years old and involves several different programs. It is incredibly complex and requires coding experience just to make any changes to the survey. My...

hello there! it's been a while since i last dropped by. once again, i am here seeking help in coming up with a Customer Satisfaction survey score predictor where possible scores in 1 survey are only: 100, 80, 60, 40, 20 & 0. say in order to pass, 1 must aim to have a 93% as an average score for...

Hello :) I am creating a survey in an excel workbook where the first tab contains a unique number for each row (survey number) and then each column has a question with a yes/no answer. There is a second tab which only needs to be completed if for example the answer to the question in column P...

Hello I want to populate a column with survey numbers from another worksheet. However I only want the survey number to appear if the answer to the question is yes. In worksheet 1 I have a column with yes/no in. There is another column with the survey number in. On worksheet 2 I have a column for...

I have an excel worksheet with 4 columns. Around 10,000ish customers. Column A (Customers took 1st survey) Column B (Score on 1st survey) Column C (Customers took 2nd survey) Column D (Score on 2nd survey) Now some customers took the 1st survey, some took the 2nd survey, some took both. I...

Hi, I have an enormous amount of data (again) that I am currently using filters to disseminate. It basically is a ton of raw surveys, with responses that could be categorized as either A - text (like guest name), B - information data (like arrival date, whether they used mobile check in, etc)...