Excel


This query is : Open 

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



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
ARTICLESHIP 29 October 2026
Article Assistant (CA Inter / CMA Inter) - Thrissur

Varma Raja & Associates

Thrissur

CA Inter

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
Featured ARTICLESHIP 28 October 2026
CA- Inter and Articles

N N V Satish & Co.,

Hyderabad

CA Inter

View Details
Company
21 October 2026
CA INTER/ BCOM WITH EXPERIENCE

CA S KUMAR GUPTA & CO

Amritsar

CA Inter

View Details
Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details