Hi everyone, I've tried finding an answer to this on my own, but to no avail.
To sum up my problem, I'm trying to write a macro that could take the input data from Sheet2 (see below) and rearrange it so that it can be used for data import in Sheet1.
Name IDs would need to be repeated...
Good Morning,
I need help with an equation to finish my skills matrix. I want the calculate the hour rate of pay to increase for every skill greater than 1.
Each skill has a total of 4 levels.
Level 1 = Basic
Level 2 = Performs with help
Level 3 = Performs well
Level 4 = Trainer
So let say...
Hi
I have 2 lots of code that I need to combine to give a result, but it is beyond my skill to do it. I assume it will be using OR somehow, but just not 100% exactly how to do it.
=IF(AND(G1256="LOST",F1256<=10),95,0)
=IF(AND(G1256="WIN",F1256<=10),-100*F1256+100,0)
Both sections seem to work...
Hi, I have searched for this elsewhere but cannot find a solved solution.
In table one I have the data as it would be, in table two I have the data as I would want it.
Can anyone help?
Name Surname Org Title Team 1 Skill 1 Skill 2 Skill 3 Skill 4 Skill 5 Skill 6 Skill 7 Skill 8 Gender In...
racking my brain trying every various combinations of formula, but using the following general setup have the user provide a "name" and a "skill" and have formula return the three most recent dates and corresponding grades.
Biggest problem i have is that the raw data is in the format that the...
Hello,
I am struggling with COUNTIF and COUNTIFS formulas so I’m hoping I may be able to get some help here?
I have two columns of data; column A contains a list of locations and column B contains either Yes, No or is blank.
There are 33 unique locations and each location appears multiple...
hello, I have a data sheet with columns A thru V and 500ish rows, Column A contains a Skill Group name (ie. MCare Contact Center) and then a list of user names in an alias format (ie. jsmith) the number of rows under the MCare Contact Center can change from day to day, anything from 1 line to...
Hello,
I have a database that I need to find out per year how many employees are active with a specific skill. To help you out the format is
Column A start date within the business (2012-2017 with full date ddd/mmm/yyy)
Column B end date within the business (2012 -207 with full date...
I have a set up data where I need to filter by teacher and get a count of scores above a certain threshold. Please help!
I use the following formula for school data
=COUNTIF(A2:A201,">9")
I need to be able to get that same count when I filter by teacher A or B. COUNTIF is not allowed with...
I have a data source which has 1 row per call. i have columns which have agent name, routing skill, and call disposition. I need each agent as a row with routing skill underneath. (no problem) Then I have the count of Calls for each skill and a subtotal (again, no problem). Here's the...
I have multiple rows of data that I need to reformat to match another much larger spreadsheet's layout.
Sorry about all the dots, I don't know how else to somewhat display the data in columns
What I have is Total hours in Skill labor and a StartDate where I calculated the Duration from the...
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...
Hi all
I don't know if what I'm trying to do is possible, or not. I can achieve it manually by looking and typing in the numbers, but I would like to automate it.
I've made a guttman chart in excel. Everything is automated except for this part which I'm really struggling with. So at present, I...
Hello All,
I'm attempting to create a personal profile. The link to this personal profile will be on a contents page which will just be hyperlinking each individuals profiles.
There is information on one workbook which shows if staff are current or able at a certain skill. Please note: there...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.