Excel working

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: 178 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
29 August 2026
Chartered Accountant

Velionit Consulting PVT LTd

Mumbai

CA

View Details
Company
ARTICLESHIP 01 September 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
ARTICLESHIP 29 August 2026
Article Assistant

RRPM & ASSOCIATES LLP

Chennai

CA Inter

View Details
Company
ARTICLESHIP 04 September 2026
Accounts Executive

Hema Yashwanth & Associates

Chennai

B.Com

View Details
Company
08 September 2026
Semi-Qualified Assitant

Subrahmanyam & Sivudu CA Firm

Hyderabad

CA Inter

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

Pravin Sarvaiya

Mumbai

CA Inter

View Details
Company
09 September 2026
Semi Qualified CA / CA Inter - 2 Groups Cleared

Getmyca Consultant Pvt Ltd

New Delhi

CA Inter

View Details
Company
08 September 2026
Audit Executive

Thammana & Associates

Srikakulam

B.Com

View Details