I need to mark the years set from the interval to show when the next maintenance will be. Is this possible without using a macro? please advise
see attached U2 16 years plan.xls.xlsx
highlighted are the column for the set intervals and the reflective year for the next inspection
Last edited by kretos88; 11-05-2013 at 02:43 PM.
You can do this pretty quickly with formulas alone.
Copy this into K2:
=IFERROR(IF(MOD(K$1-($J2-$I2),$I2)=0,"X",""),"")
And then drag down and right as needed.
year plan for kretos.xlsx
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
thanks buddy, that was some quick help. Now I'll just have to figure out the inspection due reflecting the X marks.
Originally Posted by daffodil11
If you have a pricing table by Equipment name or something, I could have it input the prices instead of X's if you prefer.
All good. just need to mark down which year the units will be maintained. thanks for the offer though
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks