Excel


Avatar

Querist : Anonymous

Profile Image
Querist : Anonymous (Querist)
29 July 2013 date debit credit bal
01-Jan-12 500000 500000
01-Jan-12 5000 495000
02-Jan-12 25000 470000
03-Jan-12 5000 475000
03-Jan-12 2500 472500
04-Jan-12 5000 477500

Res. Experts...Greetings of the day...
I want date wise balance in excel.. how to do it in excel. e.g. date 01-jan-2012 bal will be 495000.

29 July 2013 Use SUMIF FORMULAE with date

Avatar

Querist : Anonymous

Profile Image
Querist : Anonymous (Querist)
30 July 2013 My data is as under
date debit credit bal
01-Jan-12 500000 500000
01-Jan-12 5000 495000
02-Jan-12 25000 470000
03-Jan-12 5000 475000
03-Jan-12 2500 472500
04-Jan-12 5000 477500

I want to show the data in excel as under (that means only date wise balance
date bal
01-Jan-12 495000
02-Jan-12 470000
03-Jan-12 472500
04-Jan-12 477500

how to get date wise balance


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now


CCI Pro

Similar Resolved Queries


loading


Unanswered Queries



CCI Pro
Meet our CAclubindia PRO Members

Follow us
add to google news


Answer Query



Company
26 May 2026
Audit executive

vdsr & co LLP

Chennai

CA Inter

View Details
Company
ARTICLESHIP 23 May 2026
Article Assistants

Acupro Consulting

Gurgaon

CA Inter

View Details
Company
21 May 2026
Associate

PWC

Kolkata

CA

View Details
Company
29 May 2026
Accounts assistant

Shubh Consultancy

Mumbai

Graduate (Any)

View Details
Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
23 May 2026
Article Assistant

Geeta Manchanda & CO.

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 28 May 2026
Accounts, Audit & Compliance Executive

Shyam Joshi & Associates

Pune

B.Com

View Details
Company
Featured 28 May 2026
SEMI QUALIFIED/ CA DROPOUTS/ ARTICLES

T R SOOD & CO

New Delhi

CA Inter

View Details