Become a Govt. Certified GST Practitioner in just 60 hrs. Register Now!

Data consolidation in excel

CA Kumar Mukesh (CA CMA FINAL and Advance Excel Trainer) (6886 Points)

11 January 2015

Download the Practice Excel File of main Article "Data Consolidation in Microsoft Excel"

Regards,

KumarMukesh

Reply
Follow
Share

4 Replies

(Guest)

Thanks Mukesh .I tried this ,but if i want to add foreign plant details into consolidated file,then what will be the formula ?

Upgrade to CAclubindia Pro. Subscribe Now!

(Guest)

=SUM(Eastern :foreign plant!C4),I tried this but it doesn't work

CA Kumar Mukesh (CA CMA FINAL and Advance Excel Trainer) (6886 Points)
Replied 21 January 2015

Dear Mansha, There is no need to change original formula you need to just ensure that foreign plant is situated in between Easrtern to Northern sheets. For more understanding kindly go though with my article on this function.

Shraddha (Chartered Accountant) (123 Points)
Replied 31 January 2015

Dear Sir,

Very nice :)

Recent Topics

More recent discussions | Post

Related Threads

Popular Discussion

Start a New Discussion

Trending Online Classes

Course on Input Service Distributor (ISD)

Industry Expert

Enroll Now

12 April 2025
Certification Course on GST Notices Reply from AI Tools

CA Deepak Gupta

Enroll Now

12 April 2025
Certification Course on GSTR-3B Reconciliation with GSTR-2B through Chat GPT

CA Deepak Gupta

Enroll Now

26 April 2025

Data consolidation in excel

4 Replies

Online classes for CA CS CMA. Professional courses for GST, Tally, Others & Books

Leave a reply

Recent Topics

Related Threads

Popular Discussion

Trending Online Classes

Subscribe to the latest topics :

Search Forum: