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

    Summary between start and end date

    I do agree with u Mr Hui. But i want to set one formula in which as per selected date and other 2 option, i want summary from the beginning to select date in cell. can u able to help me out for that formula? please help me for that formula if u can.
  2. G

    Summary between start and end date

    thanks Xiq. i learn something new. now one more help i need. i want when i enter one date i got data form the beginning till that date which i mention. Actually my boss requirement is change now. in this same file he want that when he enter Flat no >> Type >> and date, in below data show from...
  3. G

    Summary between start and end date

    Thanks Xiq for your support. but i don't want pivot table. is want in summary sheet when i enter "flat No" - "Type" - "Start Date" - "End Date" then in below i get all data which are available in "Daily entry" sheet and as per mentioned date in summary sheet. Hope u got my point?
  4. G

    Summary between start and end date

    I have one sheet in which i enter manually all expenses daily basis. now in another sheet i want all summary from selected date. In manual entry sheet Date | Flat Block No.| Type | Description | Debit Amt | Credit Amt |Balance 18-11-13 | A | banking | Cheque Deposit | 0.00 | 5000.00 |...
  5. G

    Down time %

    hi. i am creating downtime tracker automate dashboard. now in "DATA" sheet i enter start time start date and end time and end date and set formula to calculate total duration time in hours and minutes. i am getting also the same. but now in "Forecast & Penalty deduct Amt" sheet i use formula to...
  6. G

    Excel Help !!

    Dear Sir, I am creating one downtime dashboard, now am not getting one solution. Please help me on that. In sheet 2 i have raw data and in sheet 1 i want total sum of the given criteria. In sheet i have set days like " 1 , 2 , 3 .. . . . ." Now i want from sheet 2 total downtime of same day...
  7. G

    How to find exact down time %

    Hi, My problem is how can i get down time % in worksheet sheet 1 k3 and uptime % in J3. can any one give me solution for this.
  8. G

    How to find exact down time %

    Dear Sir, I am creating new Network costing file. And i am unable to find out down time % from overall sum of down time. Please help and guide me. Attaching here excel file for your ref.
  9. G

    Regarding Macro

    Hi, I have one txt file and want to convert into excel with the help of macro. can you please provide me module for the same.
Back
Top