arrival

  1. S

    Formula for detecting a sheet

    I have this formula that I've got working IF the sheet "Arrival" already exists. However, would would I go about using this if Arrival doesn't exist? I know how I could create it with vba but trying to figure out how to do it with a formula. Thanks
  2. N

    Day or Arrival, Plus 2

    I am trying to build a formula in excel that will compare two dates. I am using =NETWORKDAYS formula to calculate the number of days in between, and that is working great. My problem is, in Cell C1, I am entering a date of arrival. What I need is: If the arrival date is a workday, then it...
  3. R

    Calculate Elapsed Time in Minutes (results may be negative, or past midnight)

    Hello, I need to calculate how many minutes early/late a train arrived. I am comparing the scheduled train arrival, versus the actual train arrival. I have tried many formulas, but can't find a formula that works for all five scenarios I've encountered in my data below. Please note I must use...
  4. R

    Need formula for Elapsed Time (negative values, times after midnight)

    Hello, I need to calculate how minutes late/early a train arrived (elapsed time) by comparing the scheduled arrival time with the actual arrival time. I have tried many different ways of doing this, but none of the ways seem to work for all four scenarios I've encountered with the data. Please...
  5. A

    Conditional Formatting different due dates

    I have looked and tried, and no luck. I need A3 to do 2 things When the arrival date is less than the number of days allowed to turn red. so it will turn red when a date is entered and also turn red automatically using today's date. A1 has arrival date A2 Has drop down list with 1 day, 3...
  6. C

    Highlighting cells with a greater time of 3hours from another cell

    Hi there, First time post on this forum. Looking for some help with the following... I have two separate columns with varying times. The first column contains an arrival time and second column with a completion time. I need the second column completion time to automatically highlight once...
  7. S

    Macro to create a new sheet and add from previous sheet

    Good Afternoon- I'm trying to figure a code to go through the following processes: I'd like to open Excel- Initial sheet is the Master Template- 1. A dialog box opens with a series of inputs (They establish the "constants" in the formulas) 2. Then Either Sheet 1 "Noon" or the Totals...
  8. S

    "Save-As" Challenge - Goodluck

    Ok I've got (what I consider to be) a challenge problem. I have a workbook with 11 worksheets that are used (there are more but not printed). FYI- I have a I was wondering if someone could write a macro code, or series of codes, that with the ActiveCommand buttons I've put in: "Noon" -...
  9. S

    Combining 2 sheets into 1 (vlookup? array?)

    Before we start, I know I can do this via vlookup but it is massively time consuming. You'll see why. The goal: to figure out when my product will arrive at my assembly centers. The issue: I have a spreadsheet from my freight forwarder. It looks like this: <tbody> PO SKU QTY Depart Date...
  10. M

    Pull values of a column of one sheet based on dates

    Hi, Sheet 1 (Named as Imports): <tbody> Column A ........ ........ ........ ...... Column G Material name Arrival date </tbody> Sheet 2 (Named as To dos): Column D I need Name of materials (arriving within in next 30 days) with their arrival date in column D of sheet 2...
  11. M

    Date range

    Hello everyone, How I can get: 1. case: arrival and departire date useing criterion 1 and date above AND In the other direction 2. case: need to get 1 in table using dates left and above? thank you very much :) <tbody> arrival departure 17.11.2017 18.11.2017 19.11.2017 20.11.2017...
  12. S

    Combining VLOOKUP and INDEX/MATCH?

    I know this is easier than I'm making it, but I can't figure out how to to a vlookup with multiple criteria, or maybe using index match? On worksheet 1(let's say colum A). I have Item numbers, then a column for preship score and a column for arrival score. On worksheet 2 in column A i have item...

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