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 14 August 2026
Article Assistant

N J Suresh & Associates

Bengaluru

CA Inter

View Details
Company
ARTICLESHIP 10 August 2026
Article Assistant

Suraj Garg and Associates

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 08 August 2026
CA Articleship

RSAG & CO LLP

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 17 August 2026
Article Assistant

Jain Ankit and Co

Gurgaon

CA Inter

View Details
Company
ARTICLESHIP 01 September 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
14 August 2026
Article Assistant CA Articleship

Eshwar & Co Chartered Accountants - Nungambakkam

Chennai

CA Inter

View Details
Company
25 August 2026
Senior Accountant

MG Associates

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 04 September 2026
Accounts Executive

Hema Yashwanth & Associates

Chennai

B.Com

View Details