Excel working

Others 336 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: 167 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.


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

View Details
Company
Featured 12 March 2026
Customer Relationship Executive

TAXLET

Calicut

B.Com

View Details
Company
Featured 14 March 2026
Article Trainee

N N V Satish&co

Hyderabad

CA Inter

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details