need help!!!

  1. S

    How to close active PDF file from excel

    Hello Everyone, Need your help to close an open pdf file using excel VBA. Appreciate your help on this. Best Regards,
  2. S

    Need help to link Cell to a seperate sheet

    Hello Everyone, Need help to link data from one sheet to a different sheet. For example, i have following data in Sheet 1 and Sheet 2: Sheet1 Cell B1 Value = A Cell B2 Value = B Cell B3 Value = C Cell B4 Value = D Cell B5 Value = E Cell B6 Value = F Cell B7 Value = G Cell B8...
  3. A

    Calculate KPI using percentages

    Hi Gurus I hope I can explain this correctly. I need to calculate a KPI using %, I got as far as creating the target. Column D is the target of 100%, so if the target is met then the achievement is 100%, I need to calculate the achievement with a max of 200%. Any ideas on how to get this done?
  4. A

    Find max value with criteria and return corresponding value

    Dear Excel Guru's I need urgent assistance. I need to find the max value on a file number and return the corresponding customer name. My image refers. I am able to find the max value for a file number but unable to return the corresponding customer name. Can someone help me?
  5. S

    Power Query help needed

    Hoping someone can help. In power query I have a column which includes days of week and schedule ex. Saturday 9:00 am 5:00 pm Tuesday 9:00 am 5:00 pm Wednesday 9:00 am 5:00 pm. Schedules in the Column are not consistent as, different hours on different days, days are different as well. I want...
  6. C

    Construction Opes - matching a rate to different sizes openings

    Hi, I have a Subcontractor who charges me different rates for various sizes opeings in walls. Example; the measured work is done on site and 0.15 is worth €2.42. what formula can put the€2.42 into the rate cells that fall between 0.1 & 0.2 etc Opes size Rate Measured works Nr rate...
  7. J

    Adding time and dates together

    I am working on a project where I am trying to add up times and dates together. Below is the data that I am working with. <tbody> Steps Time Length (Days) Time Length Converted to (H:MM) Step 1 0.33333 2:40 Step 2 2.16667 17:20 Step 3 0.33333 2:40 Step 4 0.29167 2:20 Step 5 7.97917...

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