Excel working

366 views 3 replies

Dear Friends,

Here is attached my excel working as per this statement April to June transaction  now i want to consolidate the data as per customer name for Ex. HKGN in the month of april 13 transaction are there now i need all the 13 transaction should be consolidate in single entry for april,may,june .


Attached File : 1378954 20190709144417 tcs q1 19 20 copy.xlsx downloaded: 172 times
Replies (3)
Originally posted by : rajnath
Dear Friends,

Here is attached my excel working as per this statement April to June transaction  now i want to consolidate the data as per customer name for Ex. HKGN in the month of april 13 transaction are there now i need all the 13 transaction should be consolidate in single entry for april,may,june .

 

You can use Pivots table or subtotal formula or sumif formula.
I can do this for you. But it will more better if u do this itself.

Its not working can you do it for me Please.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
24 June 2026
Chartered Accountant

CA Darshita Shah & Co

Nadiad

CA

View Details
Company
01 June 2026
Audit, Taxation & Compliance Executive

R P S K & Associates

Nashik

CA Inter

View Details
Company
ARTICLESHIP 28 June 2026
Article Assistant

Sharma Chetan And Company

Gurgaon

CA Inter

View Details
Company
ARTICLESHIP 31 May 2026
Article Assistant

KPRS And Associates

New Delhi

CA Inter

View Details
Company
19 June 2026
Accounts Executive

Getfive Advisors Pvt. Ltd.

Ahmedabad

CA Inter

View Details
Company
ARTICLESHIP 27 June 2026
Article

SNCO

Mumbai

CA Inter

View Details
Company
16 June 2026
Sr. Associate / Assistant Manager | TAS / FDD

Boutique Investment Bank & Transaction Advisory Firm

Gurgaon

CA

View Details
Company
ARTICLESHIP 24 June 2026
ARTICLE ASSISTANT

BHUPINDER SHAH AND COMPANY

New Delhi

CA Inter

View Details