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
18 September 2026
Accounts & Finance Specialist

ULTRA CHEMICAL WORKS

Thane

CA Final

View Details
Company
08 September 2026
Audit Executive

Thammana & Associates

Srikakulam

B.Com

View Details
Company
ARTICLESHIP 01 September 2026
Article Assistant

SGNG & Associates

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 16 September 2026
Article Assistant

MANUJ SHARMA AND COMPANY

Noida

CA Inter

View Details
Company
19 September 2026
CA/Semi-CA/BCom

Pravin Sarvaiya

Mumbai

CA Inter

View Details
Company
08 September 2026
Semi-Qualified Assitant

Subrahmanyam & Sivudu CA Firm

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 04 September 2026
Accounts Executive

Hema Yashwanth & Associates

Chennai

B.Com

View Details
Company
ARTICLESHIP 29 August 2026
Article Assistant

RRPM & ASSOCIATES LLP

Chennai

CA Inter

View Details