truck

  1. J

    Sumproduct with Multiple Rows and Columns

    Hi guys, Although I've been reading for a number of years, this is my first post. Please bear with me if I do something incorrectly. I have a workbook that is basically taking invoices and rolling them up by date, truck number, and expense type. The problem is there can be multiple invoices...
  2. D

    Get up to 3 unique values based on two criteria and put in variables in VBA

    Hi guys, I've searched high and low for a solution to my specific problem, but to no avail. Hence this post. I am developing an Excel database of drivers and the trucks they drove. These entries are being made via a userform throughout the month as they use the truck. The basic table as...
  3. S

    Schedule forecasting to maximize throughput

    I am trying to setup an automated scheduling spreadsheet in Excel but have hit a road block. The actual problem I'm working on is quite complex so as an example imagine a new delivery business (Acme Shipping) that is purchasing trucks and starting delivery routes. As Acme wants to maximize the...
  4. M

    Formula to stop depreciation after useful life

    The attached table, first column is the truck code,3rd column is the price of new tires, the 4th column is the depreciation cost https://photos.app.goo.gl/Gtt76KvF51Yt8xCi8 I want to depreciate the cost of new tire over 26 months So i made a formula for the 4th column...
  5. O

    Looking up Destinations

    Hi all, I am trying to create a table that I can look up my regular trips but have been out of excel for a long time and now cannot get my mind around the problem. Can somebody please help me to create this "action" as it is driving me crazy trying to achieve the end result. The "From and To"...
  6. R

    How to insert numbers in a column (between blank rows)

    I have an excel document with 8000 + rows with 23 columns and desire to populate the UID column with a number with everything associatedwith that item (between row breaks). What formula can I use to populate the UID column automatically insequential order?(I’ve populated thedata shown below)...
  7. Y

    Get last date cleaned and post to another worksheet

    Here is the table, it can have a max of 52 rows. <colgroup><col><col><col><col></colgroup><tbody> Truck Date Cleaned Type Cleaning Next Cleaning Due 1 01/18/19 Weekly 01/25/19 3 01/18/19 90 Day 04/18/19 5 01/19/19 Monthly 02/18/19 </tbody> So what I would like to do is take the last...
  8. T

    Min and OR formula Help

    I have the following formula in cell G22 and it works fine and provides the correct answer...
  9. K

    Hlookup multiple corresponding values

    Hello, I am looking for a formula that will list out all the possible transport modes horizontally to the right of Item. all the transport mode associated with the ship ID can be found on sheet 2. I need to see them all horizontally next to item in sheet 1. Please let me know if you have any...
  10. M

    extract data from sheet 1 to sheet 2

    I have a sheet columns a to i I need a macro to that will read sheet 2 cell a1 in which i will plug truck number example TR-0506 , The macro then needs to go to sheet 1 search cell a1 where it finds the truck and then pull all those rows a to i starting row a3 as a2 will have headers I need a...
  11. A

    Add a Group Number

    Hi, I am trying to create a new column in Power BI that will allow me to group my data by a subset of the entire table. Here is what I am trying to accomplish. <tbody> Event Number Unit Status Group Number 1234 Truck DP 1 1234 Car DP 2 1234 Truck AM 1 1234 Car AM 2 1234 Truck DP 3...
  12. R

    VBA - Animating an image in a worksheet

    Hello, I'm trying to make a picture look of a truck look like it's "leaving" the spreadsheet at the start of a macro and "arriving" when the macro is complete. Below is the code I have, which is close. However, it's not working quite the way I'd like. Basically what I'm trying to get is for...
  13. S

    Multiple charts from single table

    I have a set of data that tracks tread depth measurements at multiple points for each truck (64 total measurements per truck, per day); I need to create a set of charts which separates out each truck and tracks their regression over time with the horizontal axis being date and vertical...
  14. S

    Classify data by simultaneously validating 3 parameters

    Hi, I am facing a live problem and hoping that someone can help me. I have 3 trucks and bunch of vegetables and fruits and I have to distribute these products in each of these trucks. The parameters that I have to check are Type, Quality and Availability. Explained with the screenshot: <style...
  15. J

    Find 10+ number strings within text

    I have a column of data with no particular structure to the characters. They are notes containing combinations of dates, model numbers ect... I'd like to find just the strings of 10+ numbers. Sometimes the numbers are consecutive, sometimes separated by a "-", "/" or " ". Below is an example of...
  16. S

    Linking appointment schedule and reminder

    Hello, I have a daily appointment schedule that is going to be shared with 3-4 other people. We all work at the same company but at different locations. The schedule is for a truck washing station for our company trucks. Essentially the different locations are going to send their trucks to...
  17. S

    Macros to replace array formuas?

    A new question. I have another spreadsheet which is a conglomeration of data regarding truck trips. Unfortunately the design of the sheet is not conducive to getting data. I have been working on a new concept for this which would allow for sorting of different portions of the trips (basic...
  18. J

    Not sure if a nested formula or a Vlookup would work better

    Hi, I need to create a new column that will show the number of staff per vehicle in order to do further calculations. Generally if they had the same amount of staff regardless if another vehicle showed up to the incident I would use a vLookup table however there are two conditions to the number...
  19. L

    Lookup function

    No of units. Price/unit. Method. R/ unit 1. 70. Ship 1 10. 60. Truck. 1.5 100. 50. Road. 2 200. 40. Rail...
  20. L

    VBA Find and Replace all Instances of all Variables

    Hopefully this makes sense... The first sheet we will call "Pick" and is formatted like this: <tbody> SKU Description Call Name BC QTY B/O Aisle Row Tier Truck Stop 1234567 Blah Blah Blah _____ 1 301 A 1 1 1 </tbody> There is an empty row under every entry. The...

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