responses

  1. rjplante

    formula to count text inside a cell

    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...
  2. N

    VLOOUP and INDEX I think?!

    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...
  3. CatLadee

    VBA Will Not Accept Vlookup Formula that Works in Sheet

    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
  4. D

    How do I look up variations of spellings in a column list and return the correct value shown in the first row

    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...
  5. A

    Really need some formula help please .....

    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”...
  6. S

    Big Shoutout!

    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...
  7. C

    Excel form online response formatting

    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...
  8. W

    Multiple Look Ups In Table

    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...
  9. W

    Array calculation - Survey results

    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...
  10. D

    How do get Outlook Responses to Update Excel Spreadsheet

    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...
  11. W

    Need Help on Excel Leave Management

    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...
  12. Z

    Need help with Query formula

    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...
  13. A

    Daily Checklists In excel

    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...
  14. S

    Importing Answers from an Excel Based Questionnaire Into Master Data Sheet

    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...
  15. G

    Data Analysis - Related Open Ended Questions with a yes/no response

    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...
  16. A

    Round up formula

    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...
  17. T

    Survey Response - Listing responders, not counting number of responses

    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...
  18. D

    Formula to calculate percent of another tab

    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.
  19. C

    Combine multiple choice question in pivot

    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...
  20. rpaulson

    Lookup Via sheet Name

    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)...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top