qualification

  1. J

    Connect fact sheets with different dimension

    Good day everybody! I'm currently desperately trying to link three tables together so I can filter everything. I following three tables: tblEmployees <tbody> ID Name 1 Kevin 2 Arnold </tbody> tblPlan <tbody> Date ID Action 01.01.2019 1 A 02.01.2019 1 A 03.01.2019 1 Ill...
  2. P

    Change query, updated column based on cel value

    I have "inherited" a database to maintain. In it is TABLE1 with a unique staff number, followed by several columns with the qualifications each staff member can have. In TABLE2 I have feedback from trainers. They fill this in to let me know someone has a new qualification. There is one field...
  3. J

    IF formula help

    I have a massive spreadsheet of people and their qualifications. Vlookup will only return their first qualification on the list, but I need to know each one by line. I’m trying to use an “IF AND” statement. So, if column 1 contains the persons name and column 2 contains qualification name 1 (at...
  4. B

    Help in correcting excel formula

    Can anyone help me correct the following formula: =IF(C2>100,IF(T2="Change of Ropa",ROUNDUP(VLOOKUP(DATE(2006,1,1),$Q$2:$R$28,2,0)*1.86,-1)+G2),IF(C2>100,IF(OR(T2={"Superannuation","Appointment","Annual Increment","Enhancement of Qualification","10 Years' Benefit","18 Years' Benefit","20 Years'...
  5. T

    Qualification in Excel

    Hello, i have a very basic knowledge of Excel. Is there an online course that guides you through Excel with some form of certificate or recognition that i could list on a CV? I'm not worried so much about the cost, it's more having something to recognise I have learnt Excel skills.
  6. H

    Checking qualification levels before assigning possition

    Hello I have a problem The problem is that I need to find a way to get excel checking the minimum qualifications to reach a certain level. As it is now excel will check the amount of points which is in this scenario "1.000.000" so this means Champion's League (CL) but it did not pass the...

This Week's Hot Topics

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
Top