questions

I'm a little experienced with VBA but I stucked with the problem of using Checkbox's and I cannot to move on, as its a first time I prepare something using this element of UserForm. SITUATION: First thing is that I have a table, which more less look like below: <tbody> CLIENT1 CLIENT2...

Good morning everyone. I have another questions. I'm currently using this calculation: =(I6+IF(OR(I6=0,I6<H6),1,0)-H6)*24 to calculate total hours worked where H6 is In time and I6 is Out time. Thing is, it displays a "24" if there are no hours worked for that day. What would be the correct...

Hi all, I am having a problem with a thread by user Kristenisasuperstar. I read the thread and worked on a response and went to post a reply but now I can't get into the thread and get a "No thread specified. If you followed a valid link, please notify the administrator" message. Can someone...

Hello! I am a teacher who uses Moodle (an online LMS - Learning Management System). I have two Excel files that use macros to make Moodle XML files for importing questions into Moodle. I combined the two files into one, with various worksheets for either Short Answer creation, Multiple Choice...

I'm trying to determine a way to graph some polling data. I have 5 yes and no questions. I want all of the questions and answers to appear on a stacked bar graph where the percentage of the yes and no are on the same bar. Can give me an idea on how to plug the data?

Hi everyone, First time poster here! I found this site to be an amazing resource to help me achieve the first step of my Excel file, but now I have hit a wall as I can't find an answer for what I am looking to do (probably my poor searching/lack of Excel skill!). Background: I’m making a three...

I have a spreadsheet that I would like to AUTO-HIDE, AND AUTO-UN-HIDE the row based if the Column 1 value in that Row s 0. I have 20 Rows dispersed throughout 100 rows I would like to do this with, so that A1=1, Row A will auto=unhide, but if I have A1=0(or not answered yet), Row A will be...

Hi all Hopefully someone will be able to point me in the right direction with a problem I am having. I have two tables, one called Questions, this has a list of 100 questions that I need to ask each quarter. The fields are ID (Autonumber), KPIID, KPIDesc, KPITarget, KPIOwner Example data...

In my worksheet I'm trying to fill in the Zip Code column based on the City and State listed for each row. I downloaded a zip code database and added it to my worksheets a new tab in the hopes that I'd be able to use the VLOOKUP formula to populate the field from it, but I can't seem to figure...

We utilize an excel based questionnaire to gather information. We have main questions and then sub questions, The sub questions may become inapplicable based on the response to the main question. All responses are yes or or and responded to from a drop list. For Example 1. Do you own a...

I'm trying to create a randomly generating maths drill file for students My file to date is NOT attached - I can't figure out how to do it. :eeek: I did search "attach file to post" but couldn't find how to do it To start with I want the students to be able to choose if the problems will be...

I want to create a checklist in excel and I have 5 Questions. If any one of the question answer as "Yes" immediately it shall generate a email to given address and close the excel sheet. if the answer is "No" of the 5 questions it shall be closed at the end of the questions. Anybody can...

OK I have a class of three students and a test of 4 questions. Questions 1 and 3 test skill A and questions 2 and 4 test skill B. Skill A B A B Question 1 2 3 4 Student A 1 1 1 1 Student B 0 0 0 0 Student C I'm using SUMIFs and...

Hello All, I have been using some of the error handlers in my scripts. Well, i am an online learner and have learned most of these stuffs from videos where i did not get the opportunity to ask some questions. So i need help with the understanding of these error handlers. For example "on error...

<tbody> Name Test Type Marks <tbody> Priyanka </tbody> <tbody> Unit Test </tbody> <tbody> 91 </tbody> <tbody> Prakash </tbody> Unit Test 85 <tbody> Rani </tbody> Unit Test 75 <tbody> bablu </tbody> Unit Test 65 <tbody> Rajesh </tbody> Unit Test 86 <tbody> Manish...

Here I'd like to find the way to get starting 3 letters of every country. paste these values into Column A ie. AUS for Australia IND for India Many thanks <tbody> <tbody> 001-01-Australia-02-06 12-2-Japan-65 236-01-India-45-01 1401-3-Singapore-458-1 456-01-France-456-2...

Hi everyone, I'm currently new to this site and i'm in need of some excel help. Basically, I'm working for a construction company and we need to know who is on site at all times. So timing is only important, however, knowing how many people are on the site is the most important thing in...

I'm having trouble creating a COUNTIFS function with the following information: *Criteria_range1: "AvgSummer"(column R) values on "OlympicMedals" worksheet *Criteria 1: Greater than or equal to "Tier" values in "Summer" (column D) *Criteria_range2: "AvgWinter" (column S) values on...

I want to know if there are two coloumn a and b, In a we have name and b we have salary, Suppose there is a name sandeep thrice in column A and In Column B sandeep has three different salary. So How can we find out which sandeep had maximum or minimum Salary. Thanks Gajender

I'm relatively inexperienced in excel, and am hoping there is a formula or macro I can use for this. Here is a sample of my sheet: <tbody> Original ID New ID Original ID New ID 001 001 002 002 002 002 003 004 004 004 005 004 005 007 007 006 010 007 011 008 012...