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



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro

Follow us
add to google news


Answer Query



Company
ARTICLESHIP 24 June 2026
CA Article Trainee

Rahul Dang & Associates

Pune

CA Inter

View Details
Company
24 June 2026
Chartered Accountant

CA Darshita Shah & Co

Nadiad

CA

View Details
Company
ARTICLESHIP 24 June 2026
ARTICLE ASSISTANT

BHUPINDER SHAH AND COMPANY

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 27 June 2026
CA Articled Trainee And Paid Assistant

SKAA & Associates

New Delhi

CA Inter

View Details
Company
25 June 2026
Accounts & Taxation Executive

Dindukurthy & Associates

Hyderabad

MBA

View Details
Company
ARTICLESHIP 27 June 2026
Article

SNCO

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 11 July 2026
Article

SNCO

Mumbai

CA Inter

View Details
Company
22 June 2026
Finance Manager- Chartered Accountant

Triveni Turbine Limited

Bengaluru

CA

View Details