skill2

  1. I

    Using IF Statements to calculate availability

    Hi All, I'm looking to make a simple calculator to help determine when holidays are booked what skills we will lose as a consequence. Simple table below. In my simple thinking, i thought for totals an IF statement would be something as follows: If (B2=1, COUNT C2),If (B3=1, COUNT C3),If (B4=1...
  2. 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...

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