maintenance

Hi All, i have 2 columns; COlumn A is the asset number. The asset number comes up multiple times as we need to do maintenance on our assets Column B is the date the asset number had its last maintenance completed if there a formula i can use to highlight to show the last date for that asset...

I have been scratching my head for months now with this issue. Here is my main sheet with all units info : <tbody> UNIT INFO MAINTENANCE TYPE 228-12 1500 228-17 1000 336-10 500 336-15 1500 </tbody> Here is my PM sheet <tbody> UNIT MAINTENANCE TYPE DUE IN 228-12 1500 43 228-17...

I'm working on a data set as displayed below. I need to rank the maintenance and breakdown schedule of few equipment. The screenshot displays the data for 2 equipment with their maintenance schedule. Column 1&2 lists the Start date and time, Column 3&4 lists the completion date and time of...

Hi fellow excel people! I have a REALLY basic excel form here which simply keeps dates of equipment maintenance. I then have conditional formats that turn red when the date is coming up. Simple. Now, this is fine but it would be even better if the form would also send an email to a group of...

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

Hi, First post here so go easy on the (possibly) stupid question. I'm attempting to use conditional formatting to identify and highlight incorrect entries on a sheet, the entries are numeric and alphabetic, I have the numeric one working how I want it to but the alphabetic is just returning...