11/26/2018

  1. Z

    Transpose Data to Create new table

    Hi Expert, Im learning excel while I work on parsing large amount data. Need your help me to create a new table from old table as listed below. Your help is highly appreciated. Thank you once again in advance for your great help, Sincerely Zi <tbody> Source Table Order_Aging...
  2. B

    VBA Code to change one cell test based on another cell

    I need a VBA script the will allow me to look down a column and find a specific name then "Offset" to the left of that cell and change the value of the "Offset" cell. I have tried several scripts but no luck. :eeek: I have just started to learn VBA and it is killing me. I will not give up or...
  3. P

    Count Unique Values with Multiple Criteria

    How do I count the unique Dates (Col B) for each project (Col A)? I'm expecting 6 for Project A and 2 for Project B (in the sample below). <colgroup><col><col><col><col><col></colgroup><tbody> Project Sprint Project # of Sprints A 9/17/2018 A 6 A 10/1/2018 B 2 A 10/1/2018 A...
  4. B

    Calculating an average cycle time

    Hey all, I am looking for some help on finding the average cycle time for my trucks on a load cycle. I have column "B" with the start time and date and Column "C" with the end time and date. Every now and then a driver may stop for the night in the middle of one of his loads so the cycle times...

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