Data consolidation in excel

Excel 1871 views 4 replies

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

Regards,

KumarMukesh


Attached File : 304961 1396064 data consolidation.xls downloaded: 730 times
Replies (4)

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

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

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.

Dear Sir,

Very nice :)

 


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register