questions

Hey All! I have a weird request, and please delete/move if not allowed. I am about to build an excel sheet that will contain a list of all common items found in a house/garage/shed. This will then feed into another sheet where a team member can answer a few questions and it will pull the...

Good morning, In one of my excel sheets I have raw data from a likert scale with 20 questions. On another sheet I wish to tally how many of each response I received across all questions. I need help with the formula for this tallying function.

I have been using this site for years and I just realized I've been a jerk and not officially thanked or liked any posts (I hadn't noticed the little icons for doing so). I had said thank you, but not used the buttons. My question is, would it be rude to go back through and thank or like all...

Please help an old novice out. The last time I was heavy into Excel was before the year had a "2" in the front (1990's). :eeek: I have a Excel questionnaire I've made that has 5 pages to it. The first page has two drop down cells for responses. if either of the two are yes, the other pages need...

Hey everyone, I am working on a project where we took a survey from workers with about 40 questions. They are matrix questions that (IE do you strongly disagree, disagree, neutral, agree, strongly agree), that is made up of about 5 groups of questions. Each group has about 4-5 questions in it...

Hi, i have 2 SQL imports in Powerpivot from the same source, one is the Total_Data, the other is the customer id limited by SQL script to the Unique_value. I have made a relation between Total_Data and Unique_value so far so good. Now the challenge is that in the Total_Data is a column which...

This is my first attempt at building a Userform. It was actually going well and everything was working until I realized that one of my boxes was not posting a result. On the form I have a series of questions with Points awarded based on the answer. For example: It the answer to question 1 is...

I have created a questionnaire in groups of 4 questions with a potential score of 1 or 2, or 3, or 4. (numbers hidden). I want people to select their answer using a radio button and to dump the appropriate answer (number) in a cell alongside. Being new to macros and VBA I would appreciate help...

Greetings, I have a question and could use some help with an excel function. Here is what I'm trying to do. If column A contains '*001' then B=A otherwise B=A1+1 A B 1 1980001 1980001 2 1980002 1980002 3 1980003 1980003 4 1987001...

Dear all, This is my first time here. Could you please advice me with this question? I already try to search but couldn't find the answer. Each worksheet called "Project 1, 2, 3, ...., 10" and have 5 questions which each question has drop down to choose 3 variables (YES-2, PARTIAL-1, NO-0)...

Hi all, I’m working on a project on SharePoint (cloud) that will have 52 files with formulas that do a VLookup to an Excel workbook also on SharePoint. I’m doing a trial/error but have few questions to be on the safe side before I share the project: 1) If I Vlookup to a table on an external...

Hello, I am designing on Excel 2011 for Mac but the results will need to work on Excel 07 and newer. I have been asked to develop a teaching tool for my company's training department. I have the general layout designed. It's an 11x11 grid, 2 grids actually on 2 worksheets: (B2:L12) on both the...

I have a column that has duplicates, is there a way to put a formula next to the items that tells if its the first time a duplicate appears in the list? ABC (First Time or 1) CDF (First Time or 1) ABC (Second Time - or 2) EFG (First time - or 1) GHI (First time - or 1) ABC (Third...

Hi Guys, How can i add an excel file to get a help on it?

Hi, so im trying to do an averageif based on if the range contains a certain word, here is how I tried it =AVERAGEIF(D2:D892, "*"&LEFT(D2:D892,(FIND(",",D2:D892,1)-1))&"*", B2:B892) But the word it picks is the word on the same row in column D, so if i move the cell up to 5 for example, it...

I am trying to figure out the best way to create a multiple choice Quiz from excel that can be printed for students to fill out. what i have is Sheet 1 is full of test questions in Column A (rows 1 to 100 and growing) in columns B,C,D and E are the answers for the question on that row. I can...

Hi - I'm new here but have been using the forum for my Excel and VBA questions for years. I've always been able to find the answer to my questions without posting in the past, but not able with this one. Is it possible to use the Index or Offset functions to "offset" from the cell...

Hi, i'm trying to make a template. One of the questions uses radio buttons. if radio button 1(yes) is selected, no further info is needed. if radio button 2(no) is selected, extra info needs to be inserted in cell F15. (the linked cell for the radio buttons is O15) I want to delete this info...

Hello, I am trying to create a Macro that will insert the answers to two questions. The trick is that I need the the first question to go into the next empty cell in Column B and the second answer to go in the cell right next to it in Column C. I have the first part down but I can't figure...

It looks like the MrExcel forum recently exceeded 1,000,000 threads! Quite a milestone. That's a lot of answered questions! :beerchug: