agree

So I am trying to extract all of the totals for each element of a pivot table. I don't normally use PTs and this one is not mine. I need to compare each total to my data to see if I agree with the results of the PT. this is the formula that I have: =L5-GETPIVOTDATA("[Measures].[Sum of...

Hi I have the macro shown below and I need to add a few things to it but dont know where to start. What it is when I have done the auto filter for each unique criteria on both sheets I need it to compare the totals between the two sheets and if both balance then OK nothing needs doing, If not...

Hi all, So I'm trying to figure out what I need since it seems that the IFS formula has been taken away. I have several questions that students need to answer, and their choice from a drop down list is in cells H3 and the list is Agree, Disagree, Not Applicable. The results will be...

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

I have some questionnaire results to add to a chart. The responses are: strongly disagree, disagree, neutral, agree, and strongly agree. Is it possible to have the bar graph results sort in that order?

Hi, I've got some data which is assigned to a raw value, eg: Strongly Disagree = 1 Disagree = 2 Neither Agree nor Disagree = 3 Agree = 4 Strongly Agree = 5 Lets say my raw data is as follows: Data point #1 : 2 Data point #2 : 3 Data point #3 : 2 Data point #4 : 1 Data point #5 : 5 For...

Hello, I conducted a survey on people's emotional well-being after they had received a emotional counselling service. I asked respondents 5 separate questions on how effective the counselling service was with 7 response options: - Strongly agree - Agree - Neither agree or disagree - Disagree -...

Hi I want to round 1419.056 =round(1419.056,0) --> 1419.00 (why the .00, should not be 1419) =round(1419.056,1) --> 1419.10 ( why .10, should not be 1419.1) =round(1419.056,2) --> 1419.06 (this is correct, I agree with the result) Thank you.

Trying to use AND OR together. IF(AND(A1=5,B1=10)) OR IF(AND(A1=30,B1=10),A1,"") This obviously doesn't work. The OR is to allow a different choice for A1 but B1 remains the some. A1 is a 10 or 30 and B1 is constant. I need two variables for A1 to agree with B1 resulting in a TRUE

Hi, This might be a bit wordy so I apologise in advance. Basically, I have a set of data where a range of cells display either "1. Agree", "2. Agree with Recommendations" or "3. Disagree". For concreteness, let's assume that these are in A1:A5. Essentially, I would like cell A6 to display...

Hello all This is my first post on this forum and needed some help on what I am trying to do. I have data that stretches across a few cells and shows the grade the advisor received in date order and the formula I am trying to build is to check they competency rating and I want the formula to...

Hi I hope you can help I'm looking to introduce a front page to a worksheet which users must agree (tick box or click button) to the T&C's before they can look at subsequent sheets. I know how to add buttons etc but not sure how to add the security feature. Any help would be gratefully...

Hi all, Was wondering if someone could help me with this. I have a list of participants all belonging to different departments and they have all answered a number of items using the ratings "Strongly agree, Agree, No opinion, Disagree, Strongly disagree". I want to be able to count the number...

I've been handed a spreadsheet with a set of rows for a group of employees, one employee per row. Along the rows are columns for ratings. Each rating is a data validation list selecting from one of 6 terms describing performance: "Strongly Agree," "Agree," "Neutral," "Disagree," "Strongly...