banner_ad

Data consolidation in excel

Excel 2117 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: 789 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
Join CAclubindia WhatsApp Finance Community & stay updated with the latest TAX news, compliance alerts and important updates all in one place!

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
11 May 2026
Post office

Post office

Anakapalle

Others

View Details
Company
14 May 2026
Financial Analyst - Remote Finance Expert

HiringBridge

Ahmedabad

CA

View Details
Company
Featured 28 May 2026
SEMI QUALIFIED/ CA DROPOUTS/ ARTICLES

T R SOOD & CO

New Delhi

CA Inter

View Details
Company
16 May 2026
Audit clerk

mgirt & co

Bengaluru

CA Inter

View Details
Company
ARTICLESHIP 15 May 2026
Audit Assistant / Article Trainee / Intern

SSGS and Associates

Chennai

CA Inter

View Details
Company
14 May 2026
Senior Associate

ABHISHEK SHANKAR AGARWAL & ASSOCIATES

Kolkata

CA

View Details
Company
11 May 2026
CA Dropout

Patron Accounting LLP

Pune

CA Inter

View Details
Company
05 May 2026
Accountant

Sanjay K Pathak & Associates

Noida

Graduate (Any)

View Details