delivered

  1. T

    Line Chart

    Im looking to have a line chart that shows a % for the number of sku's that were delivered on time. At present everything shows at 100% ( which is wrong, as some sku's were delivered outside of their 2 day SLA ). Im not great with charts , so could do with your help. Axis: Chart Date Values...
  2. M

    DAX Formula for Cumulative and %Cumulative

    Hi, I have the following dax formulas for my cumulative total and % cumulative. Its working but not showing the correct cumulative in the technical sense Total Items Delivered: TotalItemsDelivered:=CALCULATE(COUNTROWS('DistProfile v1-3'),FILTER('DistProfile v1-3','DistProfile...
  3. R

    Calculating time based on delivered output

    Hello, I need to calculate time based on a measured output in a table. Basically I'm try to generate a standard amount of time per output. The rules are: 0 to 1 is 20 minutes flat (even if 0.1 is delivered or 0.9 it's still 20 minutes) and every unit after that is 10 minutes per unit (if 2.3...
  4. M

    Count number/share of clients that receive are being delivered daily

    Hi, I have a lists of transports. The list contains for each transport the source (warehouse), the desutination (clientID) and the shipment date. Ultimately, I want to show in a 100% bar chart the share of clients that are being delivered daily, up to 4 times per week, up to x times per week...
  5. S

    Move rows to another sheet based on cell value- VBA

    I'm very new to VBA and I'm trying to automate some processes via Excel. I have a workbook with 3 sheets: Ship In Transit Delivered I would like to be able to move the rows from Ship to In Transit or Delivered based on a value in the "W" column. If the value is In Transit to move it to the next...
  6. K

    Looking Up Data Based on a Future Date and Another Criteria

    Hello, Hope someone can help with this. I have a worksheet with a list of products, dates, delivery locations and amount being delivered (units). The products can be duplicated, as can the dates, but the delivery locations will be different if this is the case. <tbody> Product Date Delivery...
  7. D

    4 Identical Tabs with identical Ranges feed into master tab and display all data from each tab/Range

    Hi, I have an Excel report, 7 Tabs, 1 for each day of the week. 4 Separate sites fill out this report each morning. All shortages are entered into the table, whichever site opens the report first, second, 3rd or 4th (This will vary from day to day) File is not shared I purposely refrained...
  8. J

    Calculate product shipping

    Hello all, new member to the Community looking for help. I was recently given a project at work and it has to do with Excel. I’m supposed to figure out how much product is being shipped and how many are staying behind. I was given a list of Product that has been delivered and a list of the ones...
  9. P

    Check if file exist within a hardrive (folder and subfolders)

    I have an excel table with a large amount of file names (PDFs) and their description, as part of a list of documents that had to be delivered. All those files are in a folder (hard drive) organized within many subfolders, and I would like to check whether the documents they presented as...
  10. W

    pivot dates not grouping

    Hi Guys I hope you can help with an excel 2016 issue. I have a report from which I have created a pivot table. From time to time I need to update the dataset and this is causing a few issues. I am logging errors on files being delivered. The key data fields are: Filename Original Date...
  11. B

    Between dual time range

    Hey guys, I need help with a formula : in A2 I have a customer arrival time 9:48. The time window the customer can be delivered is between 8:00 (B2)- 13:00(C2) and 15:00 (D2) - 18:00 (E2). How can I see if the order was delivered outside the time windows (before 8 after 13, between 13:00 and...
  12. L

    Code to move row to a list

    Hi all, This is my first post, so please bear with me. I'm definitely not good at VBA, but I'm continuing to learn as I design new templates and I use forums like these. In the code below, I am taking any items that were delivered late on the "summary" worksheet and moving them to a list...
  13. K

    Pivot, calculated column

    Hi I have a pivot. Row names are months COL1 is number of delivered COL2 is number of delivered on time How can i add a 3rd column that calculates COL2/COL1. The third column has to work like the other so a new calculated field appears when data from march is added to the dataset. Example...
  14. D

    VBA sending email to Exchange

    Recently my company has changed EXCHANGE servers. I have been using CDO for years. Now my emails are not being delivered. I keep getting this message: Remote Server returned '550 5.7.1 RESOLVER.RST.AuthRequired; authentication required' How can I get around this? Thanks.
  15. S

    cant get cells to stay blank when no date is entered in other cells

    hello, I have a problem that i'm sure will be an easy fix but i am stumped and cannot get it to work right. The DELIVERED date is in column "O", the "LFD" column is "p". I want the LFD date to populate automatically once the delivered date is manually entered. the LFD date is the delivered...
  16. B

    Sum cells based on values in a different row

    I am trying to sum a couple ranges based on labels in another row. The reason that I need it to be based on these labels is that the range will change. I have managed to get cell addresses in a very clunky way, but I can't get them to sum. Plus, it seems like there is probably a better way to...
  17. R

    Excel 2016 VBA & MACROS - Content Update

    After registering this great book at QUE , how do i find which content is updated. I found the inside cover to be misleading , especially Actually nothing is delivered, instead one has to login to view :( I expected an ebook/pdf with highlighted content of omissions / errors or references to...
  18. D

    Vba Code too copy and paste

    Ok so here is what I have. I have a invoice spreadsheet with multiple tabs and it is starting to get lengthy. I have a column for delivered machines, simple yes or no. I want to copy the row where machines delivered "Yes" and paste to another sheet then delete the row when done. I First...

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