1/2/2019

  1. R

    Calculating difference between opened date/time and closed date/time and excluding weekends, holidays and off business hours

    I have an excel sheet that lists the opened and closed date/time for a ticket. Our SLA’s are based upon created date/time during the coverage hours – 8am ET until 5pm ET (weekends and national holiday’s, both US and India, excluded). If ticket is received prior to 8am ET or after 5pm ET, the...
  2. M

    Repeat the value until the occurrence/presence of a value using macros

    Hi All :), My input is like this . <tbody> Date ordernum Name 1/2/2019 A23423 Alex 1/2/2019 B54534 John 5/2/2019 E454 Joe 4/2/2019 C64354 Ruby </tbody> In this above excel sheet, i need to repeat the values in 1st and 2nd column until the occurrence...
  3. M

    Conditional copy paste in VBA

    Hi, I want to copy below data from sheet1 to sheet2, but only when column C AND D contain a value. If these are empty I don't want to copy paste that row. <tbody> A B C D E 1/2/2019 Natie 1000 200 1/2/2019 Discharge 1/2/2019 Load 1500 100 1/2/2019 VPC 1/2/2019 RFT 2000 500...
  4. D

    Count open for particular Shipment

    I am working on a file which has lot of data, I want to know how many days it took for a particular shipment to close ? File looks somewhat like this. Data looks somewhat like below : <colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody> Date Shipment 1/2/2019...
  5. M

    compare and color code

    I just want to compare the number in report A column G to numbers in report B row 7 and use a color code when the numbers do not match. What is the best function to do this without opening the tow reports at the same time all the times. Thank you for your help and time! Report A <tbody>...

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