responses

I have a spreadsheet that has three cells merged vertically. In this cell I enter six different letter codes to help me track performance instances. These are "A+", "A-", "m+", "m-", "+", and "-". Each of these are separated by a space within the cell. I would like to have six different cells...

Hi all, been a while! I'm creating another spreadsheet and wondered if anyone can help me out with it. I have a survey that asks a question, with responses to the question being: - Definitely - Likely - Not Sure - Unlikely - Definitely Not - N/A The downloaded sheet displays the answers in six...

Any ideas why this formula won't work in VBA but will in the worksheet? The responses tab exists. How should it be updated? THANK YOU! ActiveCell = "=IF(VLOOKUP(E2,Responses!E:R,8,FALSE)=0,"",(VLOOKUP(E2,Responses!E:R,6,FALSE)))" Range("J2").Select

Currently fielding a question in a survey which allows free form responses of different brands, as a result there are a lot of misspellings and random responses. I am building a column list of these misspellings and random responses with the correct spellings/brand as a header of the column. I...

Hi folks. I’m having a major meltdown and need to get this sorted for work. Have asked around the office and our IT dept but they say they don’t have time to work this out ( read it’s too difficult!! ) I am conducting a survey at work and the answer to the questions is either a “yes” or “no”...

Hey, I just wanted to take a moment to give a big shout out to everyone here on the forum. I really appreciate your time and assistance throughout the 1+ years that I have been on the forum. The amount of support and quick responses, not to mention clear and concise responses, has been so...

Hi everyone. Im having some challenges using online Forms for Excel. Ive made the form, but the responses from the form are all in "General" format, but no matter what I do I cannot use vlookup to pull data from it for newly received responses. I can copy and paste format only on to a...

Hello Everyone, I am trying to create a spreadsheet for a game I am playing. Essentially it will add up multiple resources from different players. Essentially the player details are entered in a spreadsheet which contains all the mixed data from all the users. I was then going to create a...

Hello, I've got a 6 questions in a survey asking in different ways whether someone feels better after using our service. People can answer Strongly agree, Agree, Neutral, Disagree or Strongly disagree to each of the 6 questions. I want to do a calculation to see how many people answered...

Hi, I am trying to use a spreadsheet to track responses that I receiving via Outlook. The responses are confidential, so I can't have the spreadsheet shared for users to update. What would be the best way to have the responses entered into the spreadsheet, without it being overly manual? My...

Hi, I am trying to track my Retail Employees via Excel. They submitted their responses via Google Form which have various Leave Types like Annual Leave, Medical Leave and etc. Form Response 1 is their responses, but I am trying to do a LookUp Table to add on their leaves for the entire period...

I have lots of data one one spreadsheet, the goal is to make a query formula that will search for all the responses a person made based on a cells critera. EX: Sheet 1 <tbody> Name: Response: X A Y B X C X D Y E Z F </tbody> Sheet 2 <tbody> Query Formula Criteria (name): X A...

Hi, i'm kind of going in circles. I'm pretty good at watching training videos and learning how to do most things in Excel. I am kind of unsure how to phrase what I'm trying to do. Looking for some direction. I created a digital form that sends responses to a google sheet. (I am including a...

If i was to design and send out 1000 questionnaires/surveys in Excel format, is there an easy way to import the responses into my Master source data sheet?? The responses would be closed ended - Yes, No .... Low, Medium, High etc. I know copy/paste seems like an obvious answer but that would...

Hi, I've searched multiple different queries with google about how to accomplish this with excel but have had no luck. I have a question on a survey which reads: Q1. What advice was given during call? I plan on grouping the responses into themes/categories which I have found out how to...

Hello, I have a formula that is kind of working but is out. <tbody> Responses Positive 93% Need Neutral Negative 100 93 92% 0 6 1 </tbody> The responses are Positive + Neutral + Negative and the results are calculated by Positive(B2) - Negative(F2) / Responses(A1). The Formula for that...

Hello, Long time lurker, first time poster here. I'm trying to create a data management system and having trouble with this one last forumla – which is the difference between me being able to sleep at night and staying up ripping my hair out. The below screenshot is a crude replication of...

I am seeking assistance writing a formula on 1 tab "Dashboard" that looks at another tab "Ed" and counts the total number of "Y" responses in column I and divides that by the total number of "Y" and "N" responses in column I and returns the percent.

Hi, So, I have a large dataset with survey responses. Among them are multiple choice responses: I'd like to add them to a pivot table with chart, displaying them like this: Unfortunately, I can't find a way to do this. The closest I get is this: Obviously, that isn't the way to go as I...

here is my formula. =HLOOKUP(A1,'[TimeCard Summary (Responses) (1).xlsx]Form Responses 1'!$1:$2,2,0) it works, but I would like to change the sheet name "Form Responses 1" to a cell referance. ex: if cell B1 = Form Responses 1 =HLOOKUP(A1,'[TimeCard Summary (Responses)...