questions

I was just wondering if all questions get answered on this forum. I asked a question yesterday under the Excel questions, but it hasn't been answered but my other threads I asked same day were. Please don't take this the wrong way, I'm very grateful for everything you all have provided, all...

I have written a Sub that I would like to post with some questions. I also have a workbook that calls that Sub to demonstrate how it works and illustrate the questions. Since attachments are not allowed, I would upload it to Dropbox and post the link. But what's the best way to do that? I...

Howdy, I have been running a number of processes at my company for years now (many were made possible from contributions from this community - thank you). I now have a new issue with files crashing Excel when loading into memory. The trouble is, it's not every file and its not every time. I...

I would like to format 200 multiple choice questions with a-d possible answers. I then will randomize 52 questions for each 20 students. I have tried importing question bank from Word 365 to Excel, but a time consuming editing process is required. So if I type in the questions in Excel, how...

Is there a for me (non literate Excel user) to extract a number of questions from a pool of test questions in Excel? The questions have in the first column numbered 1-200 I would like to pick random questions, say 52, for each person from that pool of questions. Then the next person would...

Hi There, We are trying to use excel in several ways. We have a survey that our staff fill out, a series of questions some are answered yes or no, some are answered on a scale from 1 to 5. The questions are different for each role. We currently have a workbook with a sheet for each role. The...

Might be missing the obvious but need some help. I have this data that I extract from a SharePoint survey and dump into excel. The questions all have various responses and the report is becoming tedious to maintain. I want to pull the highest response, second, third for each question. When I...

Hi, I have a series of questions in rows where there are corresponding drop down menus for each question. The questions appear one by one depending on the answer to the prior question. When a new question appears there is a delay before the corresponding drop down menu appears. The viewer sees...

Hi I am looking for assessment questions to assess my level. I did google search but I would like to know if you know good site or you have a sheet that will give me my level after answering questions. I would appreciate your help. Thank you.

Hello all, I have a spreadsheet that has a cell that when one answers a series of questions a value appears in that cell. I would like to lock all of the questions after the answer appears. Any suggestions? Thanks.

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 a 3 work sheet workbook Sheet2 is Dropdown Sheet3 is Questions Sheet6 is Switch config Im using this to create config for a network device by answering question on the questions sheet. I am building it so going to the other sheets wont be needed. The issue I have is I need to run Switch...

So, I'm new here and I want to keep getting better at excel so I want to help answer questions on the excel help board. However, I have two questions that hopefully some of the regulars can answer. 1. If I respond to one of the "Zero Reply" posts and subsequently remove it from the zero reply...

I have some data that is the answers to a questionnaire and I need to work out the lowest (and highest) 20% threshold for each question. I am aware of the PERCENTILE.INC formula, but when I use it it gives the threshold for all the questions combined, but I need this just for the individual...

Hello all. I have the table located below, but I have to organsise the data in to the format of Fig 2. Fig 1. the data the is carried over is Column D, G and H From this (Fig 1) All the info below come from the above table, as you can see the data is grouped the number is column A...

Hi, So I am trying to hide and show tabs based on different values I have a cover page, and on that cover page, I have four items listed we will call them (A, B, C, D). If "Yes" is next to A I want it to show tab A. If no is next to tab A, I want it to hide tab A. Then so on for B, C, D. I...

I have a substantial database with multiple entries for employee evaluations – each entry showing YES/NO/NA responses for up to 40 individual questions. Currently, I have a summary spreadsheet with various formulas (sumproduct, etc) that presents results based on selected employee name and...

Hello! I wrote this function but it does not work: =IF($I$28<=D17<($I$28+7),G28,C18-$C$28*0.2) I want the IF function to check the date at D17 to be between the date $I$28 and $I$28 + 1 week. How do I do that? Secondly, I want to calculate the mathematical function C18-$C$28*0.2 but I want...

When my Append quesry is ran the user gets the Pop questions (You are about to run.....) is there a way to stop this and just append the data. It confuses my users and out of precuation, they dont want to click anything and they come running to ask what to do. I want it to just go ahead and...

Hey everyone, long time browser, and i've been able to find many of my answers to questions on here. However i'm having one question stop me in my tracks. How can i get IFERROR or something similar to return the value of the cell in column P My vlookup is as follows Range("M2").Select...