PDA

View Full Version : Analysis of Amount based on following criterion.



aligahk06
04-24-2010, 04:49 AM
Dear All,

i want to analyse me data as per requirment.
The Attached file is a sample.
As per our client requirement the data analysis is as follows.
Based on Plant say LAO
Remove Cladding total Amount
Remove Insulation Total Amount
New Cladding Total Amount
New Insulation Total Amount
Reinstall Cladding Total Amount
Reinstall Insulation Total Amount
Then total ( All above six job ) for Plant Lao.
The same for all rest of the Plant i.e Col B.

Note:- I have applied sort techniques for each plant but it is tedious and time taken job.
So Im looking best way to achieve this task.


Any help.

Rgds,
Aligahk06

mdmackillop
04-24-2010, 06:22 AM
Here's a SumProduct method using dynamic ranges and data validation

aligahk06
04-24-2010, 06:57 AM
Dear MdMackillop,

Could you plz elaborate why is my attachment not appearing in your reply.
Any suggestion ?

Rgds,
Aligahk06

mdmackillop
04-24-2010, 07:11 AM
Are you not seeing an attachment in my post? I can see it and download it.

aligahk06
04-24-2010, 11:51 AM
Dear Mdmackilopp,

Good solution. Plz let us know the step how did u do this ?
As i could not understand the steps involved in accomplishing the task.

Rgds,
aligahk06

mdmackillop
04-24-2010, 12:24 PM
Sumproduct is a standard Excel function. You can read more about it here (http://www.xldynamic.com/source/xld.SUMPRODUCT.html)
The data in Plant, Job Description and Total Amount are referred to using Range Names . The Drop Downs use Data Validation. You can get information on each of these in Excel Help.

aligahk06
04-24-2010, 11:26 PM
This thread is solved.

aligahk06
04-25-2010, 12:07 AM
Dear All,

How to make a thread solved ? If the thread subscriber is satisfied with the solution.

GTO
04-25-2010, 01:00 AM
Greetings aligahk06,

Look atop your first post in the thread for the 'Thread Tools' button. There is an option under the Thread Tools button to mark it Solved :-)

Mark