satisfied

Hi all, I have a table that looks like the below example. I want to be able to use an INDEX formula to transpose figures from this vertical data, to another (working out %) which is horizontal: Table to INDEX: <tbody> Satisfied Neutral Dissatisfied Q1 222 13 10 Q2 172 10 8 Q3 82 6 7...

Good Day! I wanted to make a calculator to determine the number of perfect surveys needed to reach the target. Please see details below: Current score: 96.77% # of Surveys: 31 (30 satisfied / 1 dissatisfied) Goal: 98% Appreciate any help ?

Hello all - I am trying to figure out a way to do the following please, and could use some help: I have the following headers: A1 = TestA, B1= TestA Verified, C1= TestB, D1 = TestB Verified, E1= Time, F1= Time Verified, and finally G1 = All Tests Satisfied, I have a lookup that populates the...

Hi all, I have 14 columns of number each having 20 rows. I would like to "normalize" the data so that no row has a value that is more than 6 times the row below. I have use "do until" and "do while" macros but cannot get them to do what I want which is to keep changing the values until the...

Hi all I am looking for a Formula that would solve a problem like this: =IF(BASE!BI:BI,1,LOOKUP(DAILY!G2,BASE!D:D,BASE!AV:AV So I want to search for the value in DAILY!G2 in BASE!D:D and if found return the appropriate value from BASE!AV:AV to CELL BJ2 in DAILY! ie If the IF requirement is...

Hi everyone, I need VBA code to filter, text2column, copy and paste processed data in a new sheet. I need to return text in Question 1, question 2,... columns into number, then filter rows which in Group column is "ABC", and copy - paste these processed data in a new sheet. New sheet will...

Hi In this excel sheet, there is a column called "Satisfaction on management" (in Data2 sheet) and it has values from 1-5. So the author created a pivot table and has a Row label in pivot table like this <tbody> Satisfaction on mangment very satisfied unsatisfied mixed very unsatified...

Hi I have conducted a survey and data is according to following table.. I have data of more than 10K respondents. I want to count how many respondents are satisfied. then i want to apply different filter -criteria pair (one, two or more) to analyze the satisfaction across different groups...