assessment

Hi. I have a spreadsheet <tbody> D E 1 Question 1 90% 2 Q1 assessment criteria 1 20% 3 Q1 assessment criteria 2 30% 4 Q1 assessment criteria 2 40% </tbody> Under Question 1 there are three things users have to report on their progress with. They type in the % figure and...

Hello I would like to know how to do an index/match with multiple matches. Eg I would like to return 'date' from another sheet only if 'student ID', 'assessment name' and 'assessment type' also exactly match. I would be grateful for any help with this. Thanks Adam

Hi - first time posting here. Hope you can help. I'll try and be as clear and as concise as possible. I have 12 questions (which form part of an assessment). Each question carries a simple "Yes" or "No" answer. This gives me 4096 different possible outcomes (2^12), for a completed assessment...

I need to insert 2 columns if the header contains "*FFT Target". I've found this code, however, it does not move on to the next column containing "FFT Target" but inserts the two rows before the first column where the heading matched. Sheet headers I currently have are: <tbody> English FFT...

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.

I once again ask the help of the Excel community. In my head this is a very straight forward formula but for the life of me I can't get it to work and no amount of googling seems to help. I am trying to return the most recent (max) at of columns A & B into column C Basically stating that if...

Hi folks, I have the following lookup: =INDEX('[Form-0439 Vendor Performance Assessment 2016.xlsx]Revised'!$AU:$AU,MATCH(A:A,'[Form-0439 Vendor Performance Assessment 2016.xlsx]Revised'!$B:$B,0)) What I want is to change the lookup each year to reflect the year in the form name. I was...

Hello, I am currently using the below vba, this generates a hyperlink into a database once the item is saved into the specific file path. Sub Example1() Dim objFSO As Object Dim objFolder As Object Dim objFile As Object Dim i As Integer Sheet2.Activate 'Create an instance of the...

Hi Excel Wizards, I'd really appreciate your help with this one. I have two sets of data, the first has a list of PersonIDs and referral dates, the second has a list of IDs with assessment dates. The assessment can take place before, on the same day or after the referral date. The PersonIDs...

Hi. I am hoping someone can help me with an excel problem. I’ve added a screenshot which will hopefully help explain what I’m trying to do. I would like the 2 boxes in red to auto populate. Seems simple, but I’m sure it’s not. Impact rating - this should be the highest severity based on the...

Hello I have a table similar to the one below: <tbody> English Teacher English Teacher Target English Teacher Assessment Maths Teacher Maths Teacher Target Maths Teacher Assessment Science Teacher Science Teacher Target Science Teacher Assessment a b b- e d d i s s+ b d b f s d+ j m m-...

Hello friends, The sheet which I have created has got following columns for data entry. column a date column b particulars column c amount column c category (5 categories in drop down menu are are income & commission, expenses, expenses reimbursed, loss, loss recovered) column d funds allocated...

Hi all Hopefully this is a fairly simple one. I have a form called DataEntry which has a field called ID which is an autonumber field which produces a reference number. Once the details are added there is are two buttons that can be pressed depending on the user. If command button 1 is...

Some help here would be much appreciated in figuring out how to do this, as I feel it should be quite possible. I would like to create auto-populating lists of "To-Do's" based off of risk assessment levels, creating a task list that is ultimately sorted by likelihood. For example. I created...

Hi Guys, Hope you can help. I need to compare dates between two columns and return various types of text string. We have an assessment date which can vary and is always based on the first day of the month in a year. This needs to be compared to an earnings period date and the two dates will...

I am currently learning PowerPivot in hopes it can help our school manage student assessment and scheduling data. I have 2 main Tables uploaded to Power Pivot. In Table 1 I have the entire school schedule organized with the following design <tbody> Student ID Student Name Grade...

I am looking for some assistance on making this assessment worksheet function correctly. I have a column for the Likelihood and a column for the severity I would like to combine the likelihood and the Severity to come together to make the Risk Level ie. Frequent and Hazardious make for a High...

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>Good day all<o:p></o:p> <o:p></o:p> I was wondering if anybody would be able to assist me with a complax excel problem. I am a quality assessor and I assess various products which each have there own...

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p>Good day all<o:p></o:p> <o:p> </o:p> I was wondering if anybody would be able to assist me with a complax excel problem. I am a quality assessor and I assess various products which each have there own...