arrived

  1. B

    negative time recalculation

    <tbody> input input formula (arrived on site - driving time) DRIVING TIME ARRIVED ON SITE STARTED DRIVING 1:00 15:00 14:00 3:00 19:30 16:30 18:00 3:00 gives negative number ######## - should be 9:00 </tbody> Who can help me solving above? I calculate the 'started driving time" by...
  2. C

    vlookup base on a maximum/latest condition

    Hi guys, I am having trouble with a formula to determine the latest value on a vlookup. The following is an example: <tbody> Apples ordered 2/4/2019 Oranges backfilled 2/4/2019 Apples arrived 3/4/2019 Oranges arrived 3/4/2019 Apples backstock 4/4/2019 Oranges missing 4/4/2019...
  3. Alphacsulb

    Countif Table

    Hello, I have a reception Im going to be keeping track of those people who arrive and I need 2 formulas to keep track of how many group of people have arrived, and of those how many of them are getting an award. I'm not sure how to attach my spreadsheet anymore since I've gone to Excel 2016 so...
  4. S

    Highlight column on minimum condition

    i have 2 column from which i have arrived minimum value of 2 column like that i have around 65000 thousands row from which i want to highlighted the cell column from which minimum condition has arrived and if the value of both the column is similar then the first column should get highlighted...
  5. B

    Run macro as soon as specific text is added to a cell with numeric value already within

    Hi all, Ive managed to get work worksheet to only calculate a cell if text is added. This allows me to plot a suppliers delivery and only consider it once I add "- arrived " EG below A1 = 1000 B1 ( =A1 ) = 0 When delivery arrives A1 = "1000 arrived" B1 NOW RETURNS = 1000 As soon as I add...

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