fleet

I am trying to count distinct vehicle numbers in a fleet schedule that have come in for Maintenance between certain dates. I have used the formula below to count the number of distinct vehicles: =SUMPRODUCT(IF((Order_Date<=$O$4)*(Order_Date>=$E$4), 1/COUNTIFS(Order_Date, "<="&O4, Order_Date...

Hi guys Would like some help with this one please I have a spread sheet/ workbook assisting me with my fleet of vehicles and their varying locations daily that my staff (working different duties) require However, some days my fleet requirements are greater in some locations than others...

Hi have a workbook with 2 spread sheets sheet 1 fleet vehicles column A "fleet Numbers" column B "locations" column C "test date" column D "expire date" sheet 2 summarises location of vehicles trying to workout a formula whereby on summary sheet highlights the "fleet Number" cell when...

Hello, I need to have a macro create a new folder in 8 other folders and name them based on what is in cell A168 from the workbook that holds the macro. Once a person clicks on the button to process the macro, the macro should look in cell A168 and create new folder in each of the 8 main...

Hello All I normal only search the forum for help but no one seems to have answered my burning question. I would like a Formula but just cannot work out how to do this. (Small Story) - I have a spread sheet/ data base and I am trying to work out if I put in the fleet number it will tell me...

Hi there guys I am trying to build a spreadsheet that can return data from a master spreadsheet the master sheet consists of a number of columns a. vehicle fleet numbers b vehicle types c registration d availability e location i'm trying to find a formula that can on the second report sheet...

Hi guys I am in the need of tracking tires depths in my fleet, i want to be able to put data in another sheet of all 6 tires on the trucks, and then it be updated on another sheet, i also need a conditional formatting for when the depths reach 4. <tbody> Truck# FR FL RR RL RRR RRL Date...

Hi i need help building a Simple work sheet for 6 fleet vehicles, its needs to set up in a way, where i can update oil level on a daily basis and when it comes below 2 bars, it highlights in a different colour, please help in building this sheet, i have seen it done , i just cant figure out how...