banner_ad

Data consolidation in excel

Excel 2089 views 4 replies
User Avatar

CA CMA FINAL and Advance Excel Trainer
6886 Points Posted on 11 January 2015

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

Regards,

KumarMukesh

Attached File : 304961 1396064 data consolidation.xls downloaded: 784 times
49 Reply Share Follow
On 11 January 2015 at 03:36 Report
Replies (4)
Guest

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

Reply
On 21 January 2015 at 11:19
Guest

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

Reply
On 21 January 2015 at 11:21
User Avatar

CA CMA FINAL and Advance Excel Trainer
6886 Points Posted on 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.
49 Reply
On 21 January 2015 at 11:35
User Avatar

Chartered Accountant
123 Points Posted on 31 January 2015

Dear Sir,

Very nice :)

 

2 Reply
On 31 January 2015 at 15:32


CCI Pro

Leave a Reply

Post Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Recent Threads

More recent discussions | Post

Related Threads
Loading

Latest Job Openings

View all
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 29 April 2026
Manager- Finance and Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

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 02 May 2026
Senior Executive

hitesh chandwani & co

Pune

B.Com

View Details