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