skill

  1. W

    Macro for rearranging a range (Transpose and possibly loops)

    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...
  2. W

    Skills Matrix equation help

    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...
  3. H

    Assistance Combining Two Codes

    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...
  4. I

    Merge rows keeping all data

    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...
  5. K

    Return largest values based on text criteria

    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...
  6. 6

    Need help with this formula? Way above my skill level.

    I need help with this formula, it's above my skill level. I've worked on this for hours.... [/IMG]
  7. G

    Struggling with CountIf function

    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...
  8. T

    VBA to find specific names in column, then set a named range (up to 12 dif ranges) - range is variable from day to day

    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...
  9. P

    Find number of active employees with specific skill

    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...
  10. I

    Countif with subtotal

    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...
  11. W

    multi dimensional pivot table question with call center call data

    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...
  12. D

    'Turn' data in part of a row and calculate which column it needs to go in

    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...
  13. C

    But what if they are absent? SUMIFS

    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...
  14. R

    Automate finding the zone of proximal development in guttman chart

    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...
  15. A

    Collating data from one workbook to another in the format of a profile

    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've detected that you are using an adblocker.

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.
Go back
Back
Top