ship

  1. U

    Complex scheduling with recurrences

    Hello, I have a need to simulate jetty scheduling in excel (automatic scheduling by changing input data - number of customers, number of ships per year per customer - where different customers may have different number of ships). For a period of one year 104 ships will dock at the jetty. There...
  2. J

    Date format help

    Hello, How do I format the second half of this formula to be in date format...
  3. N

    Calculate ship day of week without using a date

    Hi! I need a formula or something that will calculate a ship day of the week without using an actual date. For example, my scenario is this: x load is delivering on a Monday. The transit time from origin is 3 days. What day of the week did the load ship? The answer would be a Wednesday (don't...
  4. D

    Sorting and deleting based on previous month

    Column J has a ton of ship dates listed as '5/20/2019 and '10/14/2018 and so on. How would I write some code to filter and delete everything but the previous months ship date. I run this report in June for May shipments, so I only want to see 5/*/2019 dates, but I run this everything so...
  5. V

    vba macro to sum by group

    Hey there, suppose I have a table like this: <colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody> V From To index decision v1 D1 A1 1 ship v2 D1 A1 1 ship v3 D1 A1 1 ship v4 D2 A2 1 ship v5 D2 A2...
  6. D

    Summing by two column criteria confusion.

    I am currently utilizing the below table format. What I am trying to do is total the dollar value in column D for a specific Customer, column G, for each month. The problem I am having is that I want to go by column N, the ship date, but, there isn't always a date in N as it may not of shipped...
  7. C

    Calculate total value up to yesterdays date

    Good morning all, Ive searched for a answer for my query but alas cannot seem to find one, can someone help please. I have a sales order due data export that I put into a simple pivot table. What I am trying to do is show a total value for orders overdue. I thought this would be simple enough...
  8. O

    Using Concatenate and If Statement... Help Needed...

    I have this formula currently. =CONCATENATE("Scheduled to Ship"," ",TEXT(V2,"m/d/yy")) However, Column V also has values that state "No Match". How can I get No Match as my return value instead of my current return of Scheduled to Ship No Match? Thanks in Advance! Kevin
  9. D

    SUMIFS excluding criteria

    So I am trying to total a dollar value for what we should be shipping for August. Easy enough, have the formula look the promise date column (L) and sum it up using a date range. The problem is sometimes we ship orders earlier than promised and I also need to look at the ship date. So if the...
  10. 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...
  11. D

    Linked File Sum If/Min If alternative?

    I have a file that performs some pretty heavy calculations but I've managed to be able to keep it running fairly smooth so far but am running into an issue with a new calculation. Essentially, the file calculates various numbers and figures each week for operations by location and by part number...
  12. J

    VBA - transfer specific data within a sheet to specific sheet by unique identifier

    Hey Mr. Excels,:cool: I am currently running a project that requires an automation on data. I have altogether 78 sheets: - 3 sheets are output data. - these 3 sheets are differentiated by payment types. - the rest of the 75 sheets are category sheets - category is located in J column in...
  13. S

    Determine start date by subtracting # hrs of work from ship date without weekends

    I have to determine the start date for production based on the ship date (ie: 4/10/18) minus production hours required. I know how to do the simple math, but I need to know the date based on 2 10 hour shifts and no weekend work. The caveat is I also want to include the start time. Example...
  14. F

    How to extract partial string onto another cell if conditions are met?

    Hi :) I was wondering if someone could help me with a formula I am having a hard time coming up with: I have an excel sheet with various recipient addresses. The recipient name column, say column A, will look something similar to "Ship to business #1584" or "Ship to business #1224" or "Jane...
  15. AshleyT

    help writing a possibly complex formula?

    Hello excel Gurus, I'm looking for help with writing a formula in a current workbook. I need a formula that will look up information in multiple tabs, and return one or multiple values into another tab. Below is a simplified table that I have in one tab of my workbook titled "Summary...
  16. J

    IF statement for Dates

    I'm trying to figure out a formula with an IF statement to generate the words SHIPPED or BACKLOG based on dates. starting Cell A2 = Order date, 1/1/17 Cell B2 = ship date, 2/1/17 If ship date is blank, generate "BACKLOG" text if ship date > order date = "SHIPPED" text text should appear in...
  17. K

    Combining information for same date and then produce report

    Hi Guys, I have data which I would like to automate for my reporting so I have raw data so firstyl i would like to group by dates if ship name is the same and if "Secondary Mode" is Breakdown also I want to group by "Description" if its the same So If Ship nm1 had breakdown in january from...
  18. M

    Need a suggestion for an fx

    I have dates in Col F and G. In F1 I need to arrive at a number showing which ones are on time and in F2 I need a count on how many are late. Col F4:F1000 is the ship date from the customer Col G4:G1000 is the required due date.
  19. S

    Excel formula to search keaywords in multiple columns

    Hello, I need your help please, I need to find a formula to search in multiple columns if the cell contains specifics key words if it is the case I need to flag the result = hopitality. <colgroup><col></colgroup><tbody> Key words Fairmont Raffles Sofitel Rixos Mc Gallery Gallery...
  20. M

    Formula help for text string data

    Hi, Please could I get some help for this formula? I have this formula that matches a text cell, to a text range, and then provides the value of a new cell. Like below. =INDEX($B$2:$B$6,MATCH(1,COUNTIF(C4,"*"&$A$2:$A$6&"*"),0)) A B C...

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