• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. V

    Counter in every cell based on multiple criteria

    Narayank991, just to clarify your Q4. Notk and Nopr are both counters but of different things. Notk counts no of breakdowns a vehicle had and Nopr counts no of repairs that same vehicle had. In some way an existing value for Nopr says that a vehicle has been repaired and that that case is...
  2. V

    Counter in every cell based on multiple criteria

    Hi Narayank991, first of all thanks for trying to help me and sorry I didn't elaborate the meaning of the KPI's that need to be calculated. Here are the answers to your questions: 1. "oti" is calculated as a simple subtraction of two consecutive values for HoW of a particular vehicle, i.e...
  3. V

    Counter in every cell based on multiple criteria

    Totally agree. I even prepared a file to upload but forgot it at work. Anyway I managed to fill some data in the worksheet that resemble the real ones. When filled with raw data it'll look something like this: http://hotfile.com/dl/142015185/3e96571/Vehicle_maint-eng.xlsx.html or...
  4. V

    Counter in every cell based on multiple criteria

    Hi, While making a Car park Maintenance data record in Excel I encountered a problem that’s beyond my scope of Excel knowledge. So after stumbling on your awesome site I thought of asking you guys for a bit of help. From the stored data I need to extract the Hours of work for a particular...
  5. V

    Hello .. Introduce yourself

    Hello, I'm Vojin and I greet you from Belgrade, Serbia. I work at Belgrade "Nikola Tesla" Airport PLC as a maintenance engineer. Joined this awesome site hoping I'll gain some Excel knowledge and later on share it with others. Cheers,
Back
Top