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