ship

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...

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

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...

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

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...

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...

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...

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...

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.

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...

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...