Excel working

365 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: 171 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
10 June 2026
Senior Account Executive

JDS Advisory LLP

Ahmedabad

CA Inter

View Details
Company
09 June 2026
Accounts Associate

S Madan and CO

New Delhi

Graduate (Any)

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

Boutique Investment Bank & Transaction Advisory Firm

Gurgaon

CA

View Details
Company
ARTICLESHIP 20 June 2026
Articleship

RB KESHRI & CO

Mumbai

B.Com

View Details
Company
ARTICLESHIP 09 June 2026
Article Trainee

Numbertree LLP

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 31 May 2026
Article Assistant

KPRS And Associates

New Delhi

CA Inter

View Details
Company
12 June 2026
Accounts & Taxation Executive

Winshine Financial Services

Mumbai

CA Inter

View Details
Company
24 June 2026
Chartered Accountant - GST & Direct Tax

APL

Mumbai

CA

View Details