responses

Hi, I have a Google Doc with one multiple choice question. The rest of the questions are identifying information. We need to convert the single row responses into multiple rows. So each "Club Listing" should have a separate row, but the other cell info should be repeated for each. I have been...

Hello, I am looking for a way (other than pivot tables) to average customer satisfaction survey results. Responses are given 1-5 and I need to average the total number of 5's for a category based on the total number of responses. With that said, not all questions are answered so I sometimes 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)...

Hello. In columns A and B (A2:A500 and B2:B500) I have a list of product names (text cells) and in column C (in the same row) their response. Response in column C (C2:C500) is also text, a binary variable: Y (Yes) or N (No). I need a formula to COUNT consecutive N (No) responses for each...

Hi, I need some help! I have made a sheet for my work on Excel which calculates NPS. It will predict NPS response rate based on the amount of guests we serve. In the sheet, the user has to input how many NPS responses we've had for promoters, passives and detractors and will then calculate...